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

with f as (select de.dept_no
                , de.emp_no
                , s.salary
                , rank() over (partition by dept_no order by salary desc ) as r
           from salaries s
                    inner join dept_emp de using (emp_no))
select dept_no
     , emp_no
     , salary as maxSalary
from f
where r = 1;