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

select emp_no,manager_no,emp_salary,manager_salary
from (select salary emp_salary, s.emp_no,dept_no from salaries s join dept_emp de on s.emp_no=de.emp_no where s.emp_no not in(select emp_no from dept_manager)) a join(select salary manager_salary,s.emp_no manager_no,dept_no from salaries s join dept_emp de on s.emp_no=de.emp_no where s.emp_no in (select emp_no from dept_manager)) b on a.dept_no=b.dept_no
where emp_salary>manager_salary

把不是manager员工的放在一个表，再把是manager员工的放在一个表，用dept_no把两个表相连