题解 | 对所有员工的薪水按照salary降序进行1-N的排名

select 
    emp_no ,
    salary ,
    dense_rank() over(order by salary desc) as t_rank
from salaries
order by t_rank asc ,emp_no asc