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

select dept_no,
(select emp_no 
from dept_emp d1 join salaries s1 using(emp_no)
where d1.dept_no=d.dept_no
order by salary desc
limit 0,1
) 
,max(salary) ms
from dept_emp d join salaries s using(emp_no)
group by dept_no
order by dept_no