题解 | #获取员工其当前的薪水比其manager当前薪水#

select e.emp_no as emp_no,f.emp_no as manager_no,e.salary as emp_salary,f.salary as manager_salary
from(
select a.emp_no,a.dept_no,b.salary
from (dept_emp a)
inner join salaries b
on a.emp_no = b.emp_no
) as e
inner join
(
select c.emp_no,c.dept_no,d.salary
from (dept_manager c)
inner join salaries d
on c.emp_no = d.emp_no
) as f
on e.dept_no = f.dept_no and e.salary > f.salary