题目

编写一个 SQL 查询来实现分数排名。如果两个分数相同，则两个分数排名（Rank）相同。请注意，平分后的下一个名次应该是下一个连续的整数值。换句话说，名次之间不应该有“间隔”。

+----+-------+ | Id | Score | +----+-------+ | 1 | 3.50 | | 2 | 3.65 | | 3 | 4.00 | | 4 | 3.85 | | 5 | 4.00 | | 6 | 3.65 | +----+-------+

例如，根据上述给定的 Scores 表，你的查询应该返回（按分数从高到低排列）：

+-------+------+ | Score | Rank | +-------+------+ | 4.00 | 1 | | 4.00 | 1 | | 3.85 | 2 | | 3.65 | 3 | | 3.65 | 3 | | 3.50 | 4 | +-------+------+

题解

无官方题解

感想

执行用时 : 913 ms, 在Rank Scores的MySQL提交中击败了51.55% 的用户

内存消耗 : N/A

# Write your MySQL query statement below SELECT s1.Score, COUNT(DISTINCT s2.Score) AS Rank FROM Scores AS s1 JOIN Scores AS s2 ON s1.Score <= s2.Score GROUP BY s1.Id ORDER BY s1.Score DESC;

用联结做的，用到了分组GROUP BY和聚合函数COUNT