#1.将salaries和dept_manager进行联结 #2.根据部门号分组group by a.emp_no select a.*,b.dept_no from salaries as a join dept_manager as b on a.emp_no=b.emp_no group by a.emp_no
#1.将salaries和dept_manager进行联结 #2.根据部门号分组group by a.emp_no select a.*,b.dept_no from salaries as a join dept_manager as b on a.emp_no=b.emp_no group by a.emp_no