代码逻辑:先分出两张表——员工、经理;然后进行薪资比较;
select e.emp_no as emp_no, m.emp_no as manage_no,e.salary as emp_salary,m.salary as manager_salary
from
(
select demp.emp_no ,demp.dept_no,s1.salary
from dept_emp demp
inner join salaries s1
on demp.emp_no=s1.emp_no
)e
inner join (
select dman.emp_no,dman.dept_no,s2.salary
from dept_manager dman
inner join salaries s2
on dman.emp_no=s2.emp_no
)m
on e.dept_no=m.dept_no
where e.salary>m.salary