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

select
    dept_emp.dept_no,
    salaries.emp_no,
    salaries.salary
from
    salaries,
    dept_emp,
    (select
    d.dept_no,
    max(s.salary) max_sa
from
    dept_emp d,
    salaries s
where
    d.emp_no = s.emp_no
group by
    d.dept_no) t
where
    salaries.emp_no = dept_emp.emp_no and t.dept_no = dept_emp.dept_no and t.max_sa = salaries.salary 
    order by dept_emp.dept_no