运行通过,解题思路:先从dept_manager,salaries中查出经理的工号,部门号,薪资,然后再从salaries和dept_emp中查出 部门号相等,工号不等,薪资大于经理的员工 工号,薪资和部门号。
select salaries.emp_no,manager_info.emp_no,salaries.salary,manager_info.salary
from salaries,dept_emp,
(
select dept_manager.emp_no,dept_no,salary
from dept_manager,salaries
where dept_manager.emp_no=salaries.emp_no
and dept_manager.to_date=salaries.to_date
)as manager_info
where not salaries.emp_no=manager_info.emp_no
and dept_emp.emp_no=salaries.emp_no
and dept_emp.dept_no=manager_info.dept_no
and salaries.salary>manager_info.salary