题解 | 每个部门薪资排名前两名员工

WITH e AS (
    SELECT
        department,
        employee_name,
        salary,
        RANK() OVER(PARTITION BY department ORDER BY salary DESC) AS s_rank
    FROM employees
)

SELECT
    department,
    employee_name,
    salary
FROM e
WHERE s_rank < 3
ORDER BY department, salary DESC