#获取员工当前的薪水比manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select a.emp_no, a.manager_no, a.emp_salary, b.salary manager_salary from ( SELECT b.emp_no emp_no, b.salary emp_salary, a.emp_no manager_no FROM dept_manager a INNER JOIN ( SELECT a.emp_no emp_no, dept_no, salary FROM dept_emp a LEFT JOIN salaries b ON a.emp_no = b.emp_no WHERE a.emp_no NOT IN ( SELECT emp_no FROM dept_manager ) ) b ON a.dept_no = b.dept_no ) a LEFT JOIN salaries b ON a.manager_no = b.emp_no where a.emp_salary > b.salary一顿连一顿试