【数据库】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