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

select#第二步,对salary进行降序
    s2.emp_no,
    s2.salary,
    dense_rank() over (
        order by
            s2.salary desc
    ) t_rank
from
    (#第一步,在子查询中将emp_no升序(默认升序)
        select
            s1.emp_no,
            s1.salary,
            row_number() over (
                order by
                    emp_no asc
            )
        from
            salaries as s1
    ) as s2