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;
sql 分组合并列并排序功能
最新推荐文章于 2024-04-30 15:35:14 发布
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;