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

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