【数据库】178. 分数排名

1 题目描述

2 解题思路

这个真的不太懂哦。。。

3 解决代码

# Write your MySQL query statement below
select s1.Score,count(distinct s2.Score) `Rank`
from Scores s1
left join Scores s2
on s1.Score <= s2.Score
group by s1.Id
order by s1.Score desc