May 7, 2009 at 12:32 pm
Is there a function I can use to rank values in TSQL so that the values will be sorted in descending order and the highest value (even if there is more than one all will have the same rank) will be ranked 1 . Sort of like the following:
Value Ranking
200 1
200 1
150 2
143 3
143 3
143 3
100 4
May 7, 2009 at 12:45 pm
Never ming the above question. They were actually wanting to calculate a percentile of the values so if someone could advise on how to go about calculating a percentile?
May 8, 2009 at 3:20 am
dndaughtery (5/7/2009)
Never ming the above question. They were actually wanting to calculate a percentile of the values so if someone could advise on how to go about calculating a percentile?
Post the expected output
Failing to plan is Planning to fail
May 8, 2009 at 4:23 am
Look up Books Online for Ranking Functions
--Ramesh
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply