题解 | #获取员工其当前的薪水比其manager当前薪水还
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
思路清晰,问题迎刃而解。
select all_no,manager_no,all_salary,manager_salary from
(select dept_emp.emp_no all_no,dept_no,salary all_salary from dept_emp left join salaries on dept_emp.emp_no = salaries.emp_no) t1
left join
(select dept_no,dept_manager.emp_no manager_no,salary manager_salary from dept_manager left join salaries on dept_manager.emp_no = salaries.emp_no) t2
on t1.dept_no = t2.dept_no
where all_salary > manager_salary