题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
/真的难阿，这道题一直在left join，left join，还要用emp_salary>manager_salary找员工工资大于经理工资怒了，写的好烦/
SELECT
de.emp_no AS emp_no,
dm.emp_no AS manager_no,
s.salary AS emp_salary,
s2.salary AS manager_salary
FROM dept_emp de
LEFT JOIN dept_manager dm ON de.dept_no = dm.dept_no
LEFT JOIN salaries s ON de.emp_no = s.emp_no
LEFT JOIN salaries s2 ON dm.emp_no = s2.emp_no
where de.emp_no not in (select emp_no from dept_manager dm) and s.salary>s2.salary
ORDER BY de.dept_no, de.emp_no;
查看20道真题和解析