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

select de.emp_no,sa.salary,sa.from_date,sa.to_date,de.dept_no
from dept_manager de left join salaries sa on de.emp_no=sa.emp_no
order by sa.emp_no