[LeetCode] 178. 分数排名

本文主要是介绍[LeetCode] 178. 分数排名，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

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

期望结果如下：

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

 

解法一：对于每一个分数，从表中找出有多少个大于或等于该分数的不重复分数，然后降序排列

select Score,
(select count(distinct Score) from Scores as s2 where s2.Score >= s1.Score) Rank 
from Scores as s1
order by Score DESC;

解法二：使用联结 join，条件是左表的分数小于等于右表的分数时，对右表的分数进行计数（即计算有几个不重复的分数大于自己，计算结果就是rank），然后根据id分组后，再根据分数降序排列

select s1.Score, count(distinct s2.Score) Rank
from Scores as s1 join Scores as s2 on s1.Score <= s2.Score
group by s1.Id 
order by s1.Score DESC;

原文链接：【LeetCode--数据库】分数排名

这篇关于[LeetCode] 178. 分数排名的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---