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

select s.emp_no, dm.emp_no, s.salary, sm.salary
from dept_emp de left join dept_manager dm on de.dept_no = dm.dept_no
join salaries s on de.emp_no = s.emp_no
join salaries sm on sm.emp_no = dm.emp_no
where s.salary > sm.salary
and de.to_date ='9999-01-01'
and dm.to_date ='9999-01-01'
and s.to_date ='9999-01-01'
and sm.to_date ='9999-01-01'