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

select
    t1.dept_no,
    t1.emp_no,
    t5.maxSalary
FROM
    dept_emp t1
    inner join salaries t4 on t1.emp_no = t4.emp_no
    inner join (
        select
            dept_no,
            max(salary) as maxSalary
        from
            salaries t2
            inner join dept_emp t3 on t2.emp_no = t3.emp_no
        group by
            t3.dept_no
    ) t5 On t1.dept_no = t5.dept_no
    and t4.salary = t5.maxSalary
order by
    t1.dept_no