SELECT Name, rank() OVER (ORDER BY Score ASC) AS RankScore FROM Rank
SELECT Name, rank() OVER (ORDER BY Score Asc) AS rankscore FROM Rank
SELECT Name, rank() OVER (ORDER BY Score DESC ) AS rankscore FROM Rank
select score, DENSE_RANK() over(order by score) as rank from Rank1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)