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

select dept_no,
emp_no,
salary
from 
(select 
    A.dept_no,
    A.emp_no,
    B.salary,
    (row_number() over (partition by A.dept_no order by B.salary DESC)) as rk
from
    dept_emp A
    left join salaries B on A.emp_no = B.emp_no
order by
    B.salary
) as D
where rk = 1
order by dept_no ASC