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

select t2.emp_no, t2.manager_no, t2.emp_salary, salaries.salary as manager_salary from

(select t1.emp_no as emp_no, dept_manager.emp_no as manager_no, salaries.salary as emp_salary

from

(select emp_no, dept_no
from dept_emp
where to_date = '9999-01-01') as t1

left join dept_manager on dept_manager.dept_no = t1.dept_no

left join (select * from salaries where to_date='9999-01-01') as salaries on salaries.emp_no = t1.emp_no) as t2

left join (select * from salaries where to_date='9999-01-01') as salaries on salaries.emp_no = t2.manager_no

where manager_salary < emp_salary