MySQL中rank() over、dense_rank() over和row_number() over怎么用

上述的这道题，如果不使用本次用到的函数的答案如下，也就是说，如果你的MySQL无法使用本篇中的函数，可以通过下面的语法逻辑做替换。

SELECT t1.Score as Score, ( SELECT COUNT(DISTINCT t2.Score) FROM Scores t2 WHERE t2.Score >= t1.Score ) AS `Rank` 
FROM Scores t1 ORDER BY t1.Score DESC

rank() over(业务逻辑)

SELECT id, name, score, rank() over(ORDER BY score DESC) AS 'rank' FROM student

dense_rank() over(业务逻辑)

SELECT id, name, score, dense_rank() over(ORDER BY score DESC) AS 'rank' FROM student

row_number() over(业务逻辑)

SELECT id, name, score, row_number() over(ORDER BY score DESC) AS 'rank' FROM student

后记

### 分班级排名
SELECT id, name, score, class, row_number() over(PARTITION BY class ORDER BY score DESC) AS 'rank' 
FROM student