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

select
    t3.dept_no as dept_no,
    t2.emp_no as emp_no,
    t3.maxSalary as salary
from
    dept_emp t1
    inner join salaries t2 on t1.emp_no = t2.emp_no
    inner join (
        select
            dp.dept_no,
            max(sal.salary) as maxSalary
        from
            dept_emp dp
            inner join salaries sal on dp.emp_no = sal.emp_no
        group by
            dp.dept_no
    ) t3 on t1.dept_no = t3.dept_no
    and t2.salary = t3.maxSalary
    order by t3.dept_no;

题目并没有说是在职的员工的最高薪资（可能暗含了吧）

虽然ac了，但感觉有点问题，请大佬们批评指正，。