Ryan Simmons
asked on
Is there a way in SQL Server to Rank() with no duplicate numbers?
Is there a way in SQL Server to Rank() with no duplicate numbers?
Currently when I attempt to rank a column Rank() will repeat the rank number for any number it encounters that is the same.
I would like a function to rank from highest to lowest value sequentially.
Currently when I attempt to rank a column Rank() will repeat the rank number for any number it encounters that is the same.
I would like a function to rank from highest to lowest value sequentially.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER