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

1张表查所有非部门经理的员工号，薪资，部门号信息
1张表查所有部门经理的员工号，薪资，部门号信息
这2张表通过部门号来连接，部门号相同时，把条件是非部门经理的工资大于部门经理的工资的信息查出来。

select nomanager.se,manager.se1,nomanager.sa,manager.sa1 
from 
(SELECT salaries.emp_no as se, salary as sa,dept_emp.dept_no as dd
from dept_emp , dept_manager , salaries
where dept_emp.dept_no=dept_manager.dept_no and dept_emp.emp_no = salaries.emp_no
and salaries.emp_no  not in(select emp_no from dept_manager)) as nomanager,
(SELECT salaries.emp_no as se1, salary as sa1 ,dept_emp.dept_no as dd1
from dept_emp , dept_manager , salaries
where dept_emp.dept_no=dept_manager.dept_no and dept_emp.emp_no = salaries.emp_no
and salaries.emp_no   in(select emp_no from dept_manager) ) as manager where 
nomanager.dd=manager.dd1 and nomanager.sa>manager.sa1;