Top 10 and Bottom 10 1

[ADB1]

Can anybody tell me the sql for getting the top 10 and WQorst ten selling products if I had the following basic sql....

Select
Product_id,
Net_Sales,
Rank(Net_Sales)
From Product

I can get the rank value but am not sure how to get the top 10 and bottom 10.

Thanks in advance.

A.

 

[CapsuleCorpJX]

Top 10:

...
Rank(Net_Sales DESC) as NetRank
...
Qualify RANK(NetRank) <= 10

Bottom 10:
...
Rank(Net_Sales ASC) as NetRank
...
Qualify RANK(NetRank) <= 10

FYI:
Rank(Net_sales) = Rank(Net_Sales DESC)
so DESC is default in ranks (top x)

 

[ADB1]

Thanks for the help. One quick question, where would you put the QUALIFY statement in your SQL? In the Where?

Thanks.

A

 

[CapsuleCorpJX]

Yea, Qualify( ) is in the where clause.