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

#先把管理表的领导人编号变为管理人编号并得到管理人薪水
#将三表连接 select de.emp_no,dms.manager_no,s.salary,dms.manager_salary
from dept_emp de
inner join (select dm.dept_no,dm.emp_no manager_no,s.salary manager_salary
from dept_manager dm
inner join salaries s
on dm.emp_no=s.emp_no) dms
on de.dept_no=dms.dept_no
inner join salaries s
on de.emp_no=s.emp_no
where de.emp_no<>dms.manager_no
and s.salary>dms.manager_salary;