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

select de.dept_no,max(s.salary) maxSalary from dept_emp de ,salaries s where de.emp_no = s.emp_no group by de.dept_no 

select demp.dept_no,demp.emp_no,sa.salary from dept_emp demp,salaries sa,
(select de.dept_no,max(s.salary) maxSalary from dept_emp de ,salaries s where de.emp_no = s.emp_no group by de.dept_no
) a 
where demp.dept_no = a.dept_no 
   and sa.emp_no = demp.emp_no 
   and sa.salary = a.maxSalary
   order by demp.dept_no