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

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