好多次联结

select
    T.dept_no, R.emp_no, T.ms as maxSalary
from
    (
    select
        d.dept_no, max(s.salary) as ms
    from
        dept_emp as d
        inner join
        salaries as s
        on d.emp_no = s.emp_no
    group by
        dept_no
    ) as T
    ,
    (
    select
        d.emp_no, d.dept_no, s.salary
    from
        dept_emp as d
        inner join
        salaries as s
        on
        d.emp_no = s.emp_no
    ) as R
where
    T.dept_no = R.dept_no
    and
    T.ms = R.salary
order by
    dept_no