题解 | #获取员工薪水比其manager还高的相关信息#

#找出部门经理当前薪水信息表t2
#找出部门关系跟薪水表t1
select t1.emp_no,t2.emp_no,t1.salary,t2.salary 
from 
    (
        select a.emp_no,a.dept_no,c.salary 
        from dept_emp a join salaries c
        on a.emp_no=c.emp_no
    ) t1 join 
    (
        select b.dept_no,b.emp_no,c.salary 
        from dept_manager b join salaries c 
        on b.emp_no=c.emp_no
    ) t2 
on t1.dept_no=t2.dept_no 
where t1.salary>t2.salary
;



;