https://leetcode.com/problems/rank-scores/
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,DENSE_RANK() OVER (ORDER BY Score DESC) AS 'Rank'
from Scores
order by score DESC
|
cs |
풀이:
스코어를 역순으로 출력하며 DENSE_RANK() OVER()를 이용하여 요구하는 중복처리를 해 줍니다.
'Leetcode' 카테고리의 다른 글
| LeetCode 181. Employees Earning More Than Their Managers [MySql] (0) | 2022.06.03 |
|---|---|
| LeetCode 180. Consecutive Numbers [MySql] (0) | 2022.06.03 |
| LeetCode 1115. Print FooBar Alternately [C++/ promise] (0) | 2022.06.03 |
| LeetCode 1114. Print in Order [C++/ atomic] (0) | 2022.06.03 |
| LeetCode 1114. Print in Order [C++/ promise] (0) | 2022.06.03 |