sqlserver
能够用row_number函数实现
例如以下:
SELECT *,row_number() OVER(ORDER BY score(列名) DESC) AS rank FROM score
sqlserver
能够用row_number函数实现
例如以下:
SELECT *,row_number() OVER(ORDER BY score(列名) DESC) AS rank FROM score
转载于:https://www.cnblogs.com/bhlsheji/p/5332637.html