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

select department,employee_name,salary
from(
select department,employee_name,salary,row_number() over (partition by department order by department desc,salary desc) as rk

from employees) a
where rk <= 2;