[SQL] Leetcode | 178. Rank Scores

dar0m! 2021. 7. 8. 22:31

178. Rank Scores

Medium

Rank Scores - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

select score, `rank`
from (
    select score, DENSE_RANK() over (order by Score desc) as `rank`
    from Scores
) score_rank
order by `rank`;

176 Second Highest Salary 를 풀고 나니 쉽게 풀 수 있던 문제 였다.
그리고 이 문제에서는 친절하게도 예약어를 탈출하려면 어퍼스트로피(`)를 사용하라는 팁도 준다.
Important Note: For MySQL solutions, to escape reserved words used as column names, you can use an apostrophe before and after the keyword. For example Rank.