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

select  t1.emp_no emp_no,
    t2.manager_no manager_no,
    t1.emp_salary emp_salary,
    t2.manager_salary manager_salary from ( select  d.emp_no emp_no,
    d.dept_no dept_no,
     s.salary emp_salary from dept_emp d left join salaries s on d.emp_no = s.emp_no )t1,
( select  de.emp_no manager_no,
    de.dept_no dept_no,
    s.salary manager_salary from dept_manager de left join salaries s on de.emp_no = s.emp_no  )t2 where t1.dept_no = t2.dept_no and t1.emp_salary > t2.manager_salary