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

select t.dept_no,s1.emp_no,s1.salary from (select de.dept_no,de.emp_no, s.salary from salaries s left join dept_emp de on s.emp_no = de.emp_no )s1 inner join (
select de.dept_no,max(s.salary) salary from salaries s left join dept_emp de on s.emp_no = de.emp_no group by de.dept_no)t on s1.dept_no = t.dept_no and s1.salary = t.salary order by t.dept_no asc

先查询出每个部门的最高工资，再和原表做关联，查询出员工姓名