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

先构建2个子表，再从子表中条件查询

select a.emp_no,b.manager_no,a.emp_salary,b.manager_salary from 
(select de.dept_no,de.emp_no,sa.salary as emp_salary from dept_emp de join salaries sa
on de.emp_no=sa.emp_no) a  join 

(select dm.dept_no,dm.emp_no as manager_no,sa.salary as manager_salary 
from dept_manager dm join salaries sa
> on dm.emp_no=sa.emp_no) b 
on a.dept_no=b.dept_no
and a.emp_salary>b.manager_salary