Advertisement
178. Rank Scores
UnknownView on LeetCode
178.sql
MySQL
SELECT
score,
DENSE_RANK() OVER(ORDER BY score DESC) AS rank
FROM Scores
ORDER BY score desc;Advertisement
Was this solution helpful?
SELECT
score,
DENSE_RANK() OVER(ORDER BY score DESC) AS rank
FROM Scores
ORDER BY score desc;