//group_concat(需要选取且连接的列名,'连接符号') select dept_no,group_concat(emp_no) as employees from dept_emp group by dept_no