本文主要介绍了SQLServer RANK() 排名函数的使用,具体如下:
— 例子表数据
SELECT * FROM test;
— 统计分数
SELECT name,SUM(achievement) achievement FROM test GROUP BY name;
— 按统计分数做排行
SELECT RANK() OVER( ORDER BY SUM(achievement) desc) 排行,name,SUM(achievement) achievement FROM test GROUP BY name;