# Write your MySQL query statement below SELECT s1.score as Score, #s2表中有分数大于等于排序后的s1表中的分数就代表排名是多少 (SELECT COUNT(DISTINCT s2.score) FROM Scores s2 WHERE s2.score>=s1.score) AS `Rank` FROM Scores s1 ORDER BY s1.score DESC;
原文：https://www.cnblogs.com/Yshun/p/15140292.html