-- ROW_NUMBER() OVER()
SELECT
* , ROW_NUMBER() OVER(PARTITION BY SUBJECT ORDER BY score DESC ) RN
FROM #Table --DENSE_RANK() OVER()
SELECT
* , DENSE_RANK() OVER(PARTITION BY SUBJECT ORDER BY score DESC ) RN
FROM #Table --RANK() OVER()
SELECT
* , RANK() OVER(PARTITION BY SUBJECT ORDER BY score DESC ) RN
FROM #Table
SELECT
* , ROW_NUMBER() OVER(PARTITION BY SUBJECT ORDER BY score DESC ) RN
FROM #Table --DENSE_RANK() OVER()
SELECT
* , DENSE_RANK() OVER(PARTITION BY SUBJECT ORDER BY score DESC ) RN
FROM #Table --RANK() OVER()
SELECT
* , RANK() OVER(PARTITION BY SUBJECT ORDER BY score DESC ) RN
FROM #Table
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货