题解 | #查找当前薪水详情以及部门编号dept_no#

/* select
s.emp_no
,s.salary
,s.from_date
,s.to_date
,d.dept_no
from 
salaries s left join dept_manager d on s.emp_no =d.emp_no
where d.dept_no is not null 
and s.to_date='9999-01-01'
and d.to_date='9999-01-01'
*/













select
s.emp_no
,s.salary
,s.from_date
,s.to_date
,d.dept_no
from salaries s left join dept_manager d
on s.emp_no = d.emp_no
where s.emp_no in (select emp_no from dept_manager ) #manager的emp_no
order by s.emp_no asc