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

SELECT de.emp_no
       ,dm.emp_no manager_no
       ,s1.salary emp_salary
       ,s2.salary manager_salary
FROM dept_emp de
join salaries s1
on de.emp_no = s1.emp_no and s1.to_date = '9999-01-01'
join dept_manager dm
on de.dept_no = dm.dept_no
join salaries s2
on dm.emp_no = s2.emp_no and s2.to_date = '9999-01-01'
where s1.salary > s2.salary