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

WITH t1 AS (
    SELECT 
        emp_no,
        salary,
        DENSE_RANK() OVER(ORDER BY salary DESC) AS t_rank
    FROM salaries
    ORDER BY t_rank ASC,emp_no ASC
)
SELECT * FROM t1;