Ranking Records

[d3c3as3d]

Would anyone tell me how you would
rank a records in (as/400) db2


product prct_count rank OR rank
aaa 99 1 4
bbb 50 2 2
eee 50 2 2
ccc 20 4 1


Thank in advance

 

[Farab]

select product, prct_count, rank() over(order by prct_count desc) as product_rank
from rank_test
order by product_rank

If you want to rank it in reverse order, then change the (order by prct_count desc) to (order by prct_count asc).

This should to the trick.