178. Rank Scores


  • 0
    I

    The basic logic of my query is to ** for every number, just find out how many numbers are there larger than itself".

    SELECT Score,
        (SELECT COUNT(DISTINCT Score)
        FROM Scores
        WHERE Score >= s.Score) Rank
    FROM Scores s
    ORDER BY Score DESC;
    

Log in to reply
 

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