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

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