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

with
t1 as(
    select
        department,
        employee_name,
        salary,
        rank()over(partition by department order by salary desc) as srank
    from
        employees
)

select
    department,
    employee_name,
    salary
from
    t1
where
    srank<=2
order by
    department,
    salary desc