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

SELECT 
    department,
    employee_name,
    salary
FROM (SELECT 
    department,
    employee_name,
    salary,
    rank() over (partition by department order by salary desc) as rk
FROM employees
) a
WHERE a.rk<=2;