LeeCode上的database题目,Rank Scores。
# Write your MySQL query statement below
set @rankNum=0;
select Scores.Score, rank_t.Rank
from Scores
left join (
select score_t.Score, (@rankNum:=@rankNum+1) AS Rank from (
select distinct Score from Scores order by Score desc
) score_t
) rank_t
on Scores.Score = rank_t.Score
order by Scores.Score desc
如果有更好的,更简洁的解法,大家多多留言,多多指教呀~