题解 | 获取每个部门中薪水最高的员工相关信息
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了，但感觉有点问题，请大佬们批评指正，