题解 | 获取所有非manager员工当前的薪水情况

SELECT
    de.dept_no,
    de.emp_no,
    s.salary
FROM dept_emp de
LEFT JOIN dept_manager dm
    ON de.emp_no = dm.emp_no
JOIN salaries s
    ON de.emp_no = s.emp_no
WHERE de.to_date = '9999-01-01'
  AND dm.emp_no IS NULL;