题解 | #查找当前薪水详情以及部门编号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 asc