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

select 
d1.emp_no as emp_no,
d2.emp_no as manager_no,
s1.salary as emp_salary,
s2.salary as manager_salary
from dept_emp d1 
join dept_manager d2 on d1.dept_no = d2.dept_no
join salaries s1 on d1.emp_no = s1.emp_no and d1.to_date = "9999-01-01"
join salaries s2 on d2.emp_no = s2.emp_no and d2.to_date = "9999-01-01"
where s1.salary > s2.salary;