Leetcode 178: Rank scores: My Solution
Free sample test question III.
with ranked as (
select *
,dense_rank() over (order by score desc) as rn
from scores
)
select score, rn as 'Rank'
from ranked
order by score desc
with ranked as (
select *
,dense_rank() over (order by score desc) as rn
from scores
)
select score, rn as 'Rank'
from ranked
order by score desc
