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

SELECT distinct employees.`emp_no`,mangers.`manger_no`,employees.`emp_salary`,mangers.`manger_salary`
FROM(
(SELECT c.`dept_no`,a.`emp_no`,a.`salary` as `emp_salary`
FROM((`salaries` a LEFT JOIN `dept_manager` b ON a.`emp_no` = b.`emp_no` ) 
	LEFT join `dept_emp` c on a.`emp_no` = c.`emp_no`)
WHERE a.`emp_no` not in (SELECT `emp_no` FROM `dept_manager`)) employees INNER JOIN
(SELECT c.`dept_no`,a.`emp_no` as `manger_no`,a.`salary` as `manger_salary`
FROM((`salaries` a LEFT JOIN `dept_manager` b ON a.`emp_no` = b.`emp_no` ) 
	LEFT join `dept_emp` c on a.`emp_no` = c.`emp_no`)
WHERE a.`emp_no` in (SELECT `emp_no` FROM `dept_manager`)) mangers
on mangers.`dept_no` = employees.`dept_no`)
WHERE employees.`emp_salary`>mangers.`manger_salary`;

我一步一步猛猛写