用窗口函数进行排名编号，然后通过子查询排序
select
    emp_no
    ,salary
    ,t_rank
from 
(
    select
        emp_no
        ,salary
        ,dense_rank() over (order by salary desc) as t_rank
    from 
        salaries
) as a
order by 3,1