题解 | 获取每个部门中薪水最高的员工相关信息

select
    t.dept_no,
    t.emp_no,
    t.salary
from
(
    select
        b.dept_no,
        a.emp_no,
        a.salary,
        row_number() over (
            partition by b.dept_no
            order by a.salary desc
        ) as rn
    from salaries a
    join dept_emp b on a.emp_no = b.emp_no
) t
where
    t.rn = 1
order by
    t.dept_no asc;