-- 部门员工当前薪资表a-- 经理当前薪资表bselect a.emp_no,b.manager_no,a.emp_salary,b.manager_salary
from(select de.*,s.salary as emp_salary
from dept_emp de join salaries s
on de.emp_no=s.emp_no
where de.to_date='9999-01-01'and s.to_date='9999-01-01')a
join(select dm.dept_no,dm.emp_no as manager_no,s.salary as manager_salary
from dept_manager dm leftjoin salaries s
on dm.emp_no=s.emp_no
where dm.to_date='9999-01-01'and s.to_date='9999-01-01')b
on a.dept_no=b.dept_no
where a.emp_salary>b.manager_salary
类型:join连接后where筛选思路:01-员工当前薪资;02-经理当前薪资;03-两表根据部门内连接,where筛选出员工薪资比经理薪资高的情况。-- 部门员工当前薪资表a-- 经理当前薪资表bselect a.emp_no,b.manager_no,a.emp_salary,b.manager_salaryfrom( select de.*,s.salary as emp_salary from dept_emp de join salaries s on de..