刚开始看到这道题我的写法是这样的：
SELECT Score,
(SELECT COUNT(*) FROM Scores S1 WHERE S1.Id != S2.Id AND S1.Score >= S2.Score) AS Rank
FROM Scores S2
ORDER BY Rank;
但是这样的输出Rank结果为：1,1,2,4,4,5。不满足题目要求，所以这里我们应该使用DISTINCT关键字来进行处理。
# Write your MySQL query statement below
SELECT Score,
(SELECT COUNT(DISTINCT Score) FROM Scores S1 WHERE S1.Score >= S2.Score) AS Rank
FROM Scores S2
ORDER BY Rank;
LeetCode 178. Rank Scores 题目 Write a SQL query to rank sc...
题目链接： 178. Rank Scores 解析： 刚开始看到这道题我的写法是这样的： 但是这样的输出Rank结...
Write a SQL query to rank scores. If there is a tie betwe...
Description: Write a SQL query to rank scores. If there i...
177.Nth Highest Salary 178.Rank Scores Write a SQL query ...
leetcode数据库类型：178. 分数排名，难度：中等 解答： rank() over，作用：查出指定条...
链接：https://leetcode-cn.com/problems/rank-scores 编写一个 SQL ...
1.Nth Highest Salary 2. Rank Scores 3.找出连续出现的字段Consecutiv...
将sname，degree，rank三表组合匹配成一张新表grade表scores表student表
rank.rb Usage:ruby rank.rb or ruby rank.rb -d
本文标题：178. Rank Scores
本文链接：https://www.haomeiwen.com/subject/bvudmftx.html
网友评论