11.获取所有员工当前的manager
题目内容:
代码及思路:
SELECT dept_emp.emp_no,dept_manager.emp_no AS manager_no
FROM dept_emp,dept_manager
WHERE dept_emp.emp_no <> dept_manager.emp_no
AND dept_emp.dept_no = dept_manager.dept_no
AND dept_manager.to_date='9999-01-01'
11.获取所有员工当前的manager
题目内容:
代码及思路:
SELECT dept_emp.emp_no,dept_manager.emp_no AS manager_no
FROM dept_emp,dept_manager
WHERE dept_emp.emp_no <> dept_manager.emp_no
AND dept_emp.dept_no = dept_manager.dept_no
AND dept_manager.to_date='9999-01-01'