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

select
    t3.dept_no,
    t3.emp_no,
    t3.maxSalary
from
    (select 
        t1.dept_no,
        t1.emp_no,
        t2.salary,
        max(t2.salary) over(partition by t1.dept_no) maxSalary
    from 
        dept_emp t1
    left join
        salaries t2
    on 
        t1.emp_no = t2.emp_no
    ) t3
where 
    t3.salary = t3.maxSalary
order by
    t3.dept_no