题解 | #获取所有非manager员工当前的薪水情况#
获取所有非manager员工当前的薪水情况
http://www.nowcoder.com/practice/8fe212a6c71b42de9c15c56ce354bebe
/* #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)