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

# select de.dept_no, s.emp_no, s.salary
# from salaries s, dept_emp de, dept_manager dm
# where s.emp_no = de.emp_no and de.dept_no = dm.dept_no and de.emp_no != dm.emp_no;

# select de.dept_no, s.emp_no, s.salary
# from salaries s
# join dept_emp de on s.emp_no = de.emp_no
# where s.emp_no not in (
#     select emp_no
#     from dept_manager
# ) and s.to_date = '9999-01-01';

# select de.dept_no, s.emp_no, s.salary
# from salaries s
# join dept_emp de on s.emp_no = de.emp_no
# left join dept_manager dm on s.emp_no = dm.emp_no
# where dm.emp_no is null and s.to_date = '9999-01-01';

select de.dept_no, s.emp_no, s.salary
from salaries s
join dept_emp de on s.emp_no = de.emp_no
where not exists (
    select 1
    from dept_manager dm
    where dm.emp_no = s.emp_no
);