【WM_CONCA()】分组逗号拼接字段,(WM_CONCAT(要拼接的字段名),分组不要把拼接的字段分组)
表名 test
select sum(one) as one,two,WM_CONCA(three) asthree fromtest group by two;
结果
时间:2024-06-18 04:21:20
【WM_CONCA()】分组逗号拼接字段,(WM_CONCAT(要拼接的字段名),分组不要把拼接的字段分组)
表名 test
select sum(one) as one,two,WM_CONCA(three) asthree fromtest group by two;
结果