SELECT d.dept_no, d.emp_no, s.salary FROM dept_manager AS d, salaries AS s WHERE (
d.emp_no = s.emp_no AND s.to_date = '9999-01-01' AND d.to_date = '9999-01-01'
)
SQL实战之获取所有部门当前manager当前的薪水
最新推荐文章于 2022-09-03 08:21:13 发布
SELECT d.dept_no, d.emp_no, s.salary FROM dept_manager AS d, salaries AS s WHERE (
d.emp_no = s.emp_no AND s.to_date = '9999-01-01' AND d.to_date = '9999-01-01'
)