24.获取所有非manager员工当前的薪水情况
题目内容:
代码及思路:
因为是要非manager,因此肯定需要添加条件emp_no NOT IN (SELECT emp FROM dept_manager)
SELECT de.dept_no,de.emp_no,sa.salary
FROM dept_emp de,salaries sa
WHERE de.to_date='9999-01-01'
AND sa.to_date='9999-01-01'
AND de.emp_no=sa.emp_no
AND de.emp_no NOT IN (SELECT emp_no FROM dept_manager);