题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息
select
t1.emp_no,
manager_no,
t1.salary,
salaries.salary as manager_salary
from
(
select
salaries.emp_no,
dept_manager.emp_no as manager_no,
salaries.salary
from
salaries
left join dept_emp on salaries.emp_no = dept_emp.emp_no
left join dept_manager on dept_emp.dept_no = dept_manager.dept_no
) t1
left join salaries on t1.manager_no=salaries.emp_no
where t1.salary>salaries.salary
投递华为等公司10个岗位