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

SELECT
    emp_no,
    salary,
    DENSE_RANK() OVER (
        ORDER BY salary DESC
    ) AS salary_rank
FROM salaries
WHERE to_date = '9999-01-01'
ORDER BY
    salary_rank ASC,
    emp_no ASC;