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

select e.dept_no,e.emp_no,s.salary
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) as maxSalary
from dept_emp e 
join salaries s on e.emp_no=s.emp_no
group by e.dept_no)
order by e.dept_no asc