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

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