好多次联结
获取每个部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/questionTerminal/4a052e3e1df5435880d4353eb18a91c6
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
