本文主要介紹了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;