sql 分组合并列并排序功能

SELECT a.组id,group_concat(a.属性 ORDER BY a.属性 ) from 表 a GROUP BY 组id;

SELECT a.组id,group_concat(a.属性 ) from (SELECT * FROM 表  ORDER BY 属性 ) a GROUP BY 组id;