立即学习:https://edu.csdn.net/course/play/27328/370699?utm_source=blogtoedu
select dept,count(*),group_concat(name,salary order by salary asc separator ';') from employee group by dept;
立即学习:https://edu.csdn.net/course/play/27328/370699?utm_source=blogtoedu
select dept,count(*),group_concat(name,salary order by salary asc separator ';') from employee group by dept;