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

select 
emp_no,
salary,
dense_rank() over (order by salary desc) as t_rank
from salaries
where to_date='9999-01-01'
order by t_rank asc,emp_no asc;#rank是关键字