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

SELECT d1.emp_no,d2.manager_no,d1.emp_salary,d2.manager_salary FROM (select de.dept_no,de.emp_no as emp_no,s.salary as emp_salary from dept_emp de INNER JOIN salaries s ON de.emp_no=s.emp_no) d1 LEFT JOIN (select dm.dept_no,dm.emp_no as manager_no,s.salary as manager_salary from dept_manager dm INNER JOIN salaries s ON dm.emp_no=s.emp_no) d2 ON d1.dept_no=d2.dept_no WHERE emp_salary>manager_salary;

/*先建立两个表 一个是员工的薪水表一个是经理薪水表 左连接可能比内连接快一些 再利用where筛选条件 */