sqlserver
可以用row_number函数实现
如下:
SELECT *,row_number() OVER(ORDER BY score(列名) DESC) AS rank FROM score