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

select es.emp_no, ms.emp_no manager_no, es.salary emp_salary, ms.salary manager_salary
from 
(select de.emp_no, s1.salary, de.dept_no from dept_emp de inner join salaries s1 on de.emp_no = s1.emp_no where de.to_date = "9999-01-01") es
inner join 
(select dm.emp_no, s2.salary, dm.dept_no from dept_manager dm inner join salaries s2 on dm.emp_no = s2.emp_no where dm.to_date = "9999-01-01") ms
on es.dept_no = ms.dept_no
where es.salary > ms.salary

(select de.emp_no, s1.salary, de.dept_no from dept_emp de inner join salaries s1 on de.emp_no = s1.emp_no where de.to_date = "9999-01-01") es 查出当前在职的员工的员工号，薪水，部门号并命名为es (select dm.emp_no, s2.salary, dm.dept_no from dept_manager dm inner join salaries s2 on dm.emp_no = s2.emp_no where dm.to_date = "9999-01-01") ms 查出当前在职的领导的领导号，薪水，部门号并命名为ms es 和 ms用部门号连接，并且es的薪水高于ms的薪水