4. My solution

My solution

  • 0
    N

    SET @r := 1, @s := (SELECT MAX(Score) FROM Scores);

    SELECT Score,Rank
    FROM
    (SELECT Score, IF(@s = Score,@r,@r:=@r+1) AS Rank, @s:=Score
    FROM Scores
    ORDER BY Score DESC) as t

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.