题解 | 刷题通过的题目排名

# select id,number,
#     dense_rank() over(order by number DESC) dr
# from passing_number
# order by 
#     dr ASC,id ASC;


select id,number,
    dense_rank() over(order by number DESC) as  'dr'
from passing_number
order by 
    dr ASC,id ASC;