题解 | #获取员工其当前的薪水比其manager当前薪水

#匹配员工的manager
select 
emp_no,
manager as manager_no,
s1 as emp_salary,
s2 as manager_salary
from
(select
t1.emp_no,
t1.manager,
s.s1,
ss.s2
from
(
select 
d.emp_no,
d.dept_no,
m.emp_no as manager
from dept_emp d
left join dept_manager m on d.dept_no = m.dept_no
)t1
left join (select emp_no,salary as s1 from salaries) s on t1.emp_no = s.emp_no
left join (select emp_no,salary as s2 from salaries) ss on t1.manager = ss.emp_no
)t2
where s1>s2