[LeetCode] 178. Rank Scores

내 쿼리

SELECT score
    ,DENSE_RANK() OVER (ORDER BY score DESC) AS 'rank'
FROM scores
ORDER BY score DESC

 

- RANK

- DENSE_RANK

- ROW_NUMBER

 

RANK() OVER ((PARTITION BY ~) ODER BY ~)