题解 | top2的薪水排名

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
ORDER BY department,salary DESC; --在之前一道题的基础上加上filter