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;
03-16
9492
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
09-22
2749
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-08
1404
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)