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

/*
#1.找到非manager的员工
select e.emp_no
from employees as e, dept_emp as de
where e.emp_no <> de.emp_no
*/
SELECT de.dept_no, de.emp_no, s.salary
FROM dept_emp as de
join salaries as s
on de.emp_no = s.emp_no
where de.emp_no NOT IN (select e.emp_no
from employees as e, dept_manager as mag
where e.emp_no = mag.emp_no)