做排
SQLServerRANK()排名函数
rank函数的用法SQLServerRANK()排名函数-- 例⼦表数据SELECT * FROM test;-- 统计分数SELECT name,SUM(achievement) achievement FROM test GROUP BY name;-- 按统计分数做排⾏SELECT RANK() OVER( ORDER BY SUM(achievement) desc) 排⾏,name,SU...
rank函数的用法SQLServerRANK()排名函数-- 例⼦表数据SELECT * FROM test;-- 统计分数SELECT name,SUM(achievement) achievement FROM test GROUP BY name;-- 按统计分数做排⾏SELECT RANK() OVER( ORDER BY SUM(achievement) desc) 排⾏,name,SU...