[LeetCode] Rank Scores - SQL
来源:互联网 发布:查看ubuntu位数 编辑:程序博客网 时间:2024/06/05 05:16
Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value. In other words, there should be no "holes" between ranks.
+----+-------+| Id | Score |+----+-------+| 1 | 3.50 || 2 | 3.65 || 3 | 4.00 || 4 | 3.85 || 5 | 4.00 || 6 | 3.65 |+----+-------+
For example, given the above Scores
table, your query should generate the following report (order by highest score):
+-------+------+| Score | Rank |+-------+------+| 4.00 | 1 || 4.00 | 1 || 3.85 | 2 || 3.65 | 3 || 3.65 | 3 || 3.50 | 4 |+-------+------+
# Write your MySQL query statement belowSELECT Score, Rank FROM( SELECT Score, @curRank := @curRank + IF(@prevScore = Score, 0, 1) AS Rank, @prevScore := Score FROM Scores s, (SELECT @curRank := 0) r, (SELECT @prevScore := NULL) p ORDER BY Score DESC) t;
0 0
- [LeetCode] Rank Scores - SQL
- LeetCode | Rank Scores
- leetcode 178 Rank Scores
- Leetcode: Rank Scores
- [LeetCode][Database]Rank Scores
- LeetCode Rank Scores
- Database LeetCode Rank Scores
- leetcode 178. Rank Scores
- Leetcode 178. Rank Scores
- 【leetcode】Rank Scores
- LeetCode.178 Rank Scores
- Leetcode刷题 sql算法题 178 Rank Scores
- [LeetCode]Rank Scores,解题报告
- [LeetCode]Rank Scores,解题报告
- leetcode-database-178.Rank Scores
- leetcode-database-178. Rank Scores
- 【leetcode Database】178. Rank Scores
- Rank Scores
- ios开发-c语言之进制和位运算的学习
- HDU 5003 Osu!(水题)
- MYSQL常用命令列表
- Getting around non-executable stack (and fix)
- Shell 中的awk命令
- [LeetCode] Rank Scores - SQL
- UDP、TCP、RTP三种协议的总结
- 【OpenCV】矩阵操作总结
- 利用perl 改写awk统计
- 给Access Database添加密码
- 【网站开发】在新浪SAE上搭建一个博客
- hdu 5185
- 23种设计模式(20):责任链模式
- liunx常用命令