题解 | #获取所有非manager员工当前的薪水情况#
SELECT
T2.dept_no,
T1.emp_no,
T4.Salary
FROM
employees T1
LEFT JOIN
dept_emp T2
ON T1.emp_no = T2.emp_no
LEFT JOIN
salaries T4
ON T1.emp_no = T4.emp_no
WHERE T1.emp_no NOT IN
(
SELECT T3.emp_no FROM dept_manager T3
)
AND T2.dept_no IS NOT NULL
AND T1.emp_no IS NOT NULL
AND T4.Salary IS NOT NULL
投递小天才等公司10个岗位
