题解 | #获取所有非manager员工当前的薪水情况#
获取所有非manager员工当前的薪水情况
https://www.nowcoder.com/practice/8fe212a6c71b42de9c15c56ce354bebe
SELECT de.dept_no, emp.emp_no, s.salary
FROM employees as emp
LEFT JOIN dept_emp as de
ON emp.emp_no = de.emp_no
LEFT JOIN dept_manager as de_ma
ON emp.emp_no = de_ma.emp_no
LEFT JOIN salaries as s
ON emp.emp_no = s.emp_no
WHERE emp.emp_no not in (
SELECT emp_no
FROM dept_manager
)
投递百度等公司10个岗位
