1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| -- @Title: 分数排名 (Rank Scores)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 15:55:32
-- @Runtime: 677 ms
-- @Memory: 0 B
# Write your MySQL query statement below
select
S1.score 'Score',
count(DISTINCT S2.score) 'Rank'
FROM
Scores S1
INNER JOIN Scores S2
ON S1.score <= S2.score
GROUP BY
S1.id, S1.score
ORDER BY S1.score DESC;
|