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

select
    e.dept_no,
    e.emp_no,
    s.salary maxSalary
from
    dept_emp e
    join salaries s on e.emp_no = s.emp_no
where
    (e.dept_no, s.salary) in (
        select
            e.dept_no,
            max(s.salary)
        from
            dept_emp e
            join salaries s on e.emp_no = s.emp_no
        group by
            1
    )
order by
    e.dept_no