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

select emp1.emp_no as emp_no  ,emp1.manager_no as manager_no,emp1.emp_salary as emp_salary,emp2.emp_salary as emp_salary from
(select d.emp_no,m.emp_no as manager_no,s.salary as emp_salary
from dept_emp d,
     dept_manager m,
     salaries s
where d.dept_no = m.dept_no and
      d.emp_no = s.emp_no) as emp1,
(select d.emp_no,m.emp_no as manager_no,s.salary as emp_salary
from dept_emp d,
     dept_manager m,
     salaries s
where d.dept_no = m.dept_no and
      m.emp_no = s.emp_no) as emp2
where emp1.emp_no = emp2.emp_no and
      emp1.emp_salary > emp2.emp_salary