mysql把某字段多行值拼接成一行

原始数据:

code name z_date
1 aaa 20241220
1 aaa 20241221
1 aaa 20241222
2 bbb 20241219
2 bbb 20241220

输出结果:

code name z_date
1 aaa 20241220,20241221,20241222
2 bbb 20241219,20241220

SQL:

select  code,name,count(n),GROUP_CONCAT(z_date order by z_date asc  SEPARATOR  ', ') from z_data group by code,name order by 3 desc;
posted @ 2024-12-24 17:17  阳光下的小水仙  阅读(35)  评论(0)    收藏  举报