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

- 分窗函数先算出每个部门的薪资排名，然后再嵌套查询排名第一的人
select dept_no, emp_no, salary as maxSalary
from
(select dept_no, emp_no, salary,
rank() over (partition by dept_no order by salary desc) as rk
from dept_emp a
join salaries b
using(emp_no)) t1
where rk = 1