题目地址:https://leetcode.com/problems/rank-scores/
SELECT Score, (
SELECT COUNT(DISTINCT Score)
FROM Scores AS c
WHERE o.Score <= c.Score
) AS Rank
FROM Scores AS o
ORDER BY Score DESC;
题目地址:https://leetcode.com/problems/rank-scores/
SELECT Score, (
SELECT COUNT(DISTINCT Score)
FROM Scores AS c
WHERE o.Score <= c.Score
) AS Rank
FROM Scores AS o
ORDER BY Score DESC;