select dept_no,GROUP_CONCAT(emp_no order by emp_no separator ',') as employees
from dept_emp group by dept_no order by dept_no;
运用的是分组合并函数:group_concat
select dept_no,GROUP_CONCAT(emp_no order by emp_no separator ',') as employees
from dept_emp group by dept_no order by dept_no;
运用的是分组合并函数:group_concat