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

select emp_no,manager_no,emp_salary,manager_salary
from
(
select d1.emp_no,d2.emp_no manager_no,s.salary emp_salary,ss.salary manager_salary
from dept_emp d1 join dept_manager d2 on d1.dept_no=d2.dept_no
join salaries s on d1.emp_no =s.emp_no 
join salaries ss on d2.emp_no = ss.emp_no
where d1.to_date = '9999-01-01'
) sq
where emp_no != manager_no and emp_salary>manager_salary