数据库SQL实战 No.9
获取所有部门当前manager的当前薪水情况,给出dept_no, emp_no以及salary
http://www.nowcoder.com/questionTerminal/4c8b4a10ca5b44189e411107e1d8bec1
SELECT dept_manager.dept_no, dept_manager.emp_no, salaries.salary FROM dept_manager, salaries
WHERE salaries.to_date = '9999-01-01' AND dept_manager.to_date = '9999-01-01' AND dept_manager.emp_no = salaries.emp_no
ORDER BY dept_manager.dept_no ASC
数据库SQL实战答案 文章被收录于专栏
该专栏为“数据库SQL实战”的配套题解