现在的表如下:
table1 = table(10:0, ["id", "value"], [INT, STRING]) insert into table1 values((1,1,2,2,3,3), `1`2`3`4`5`6)
想得到这样一张表:
请问应该如何实现?
提供一种解决方法:
select concat(string(value), ",") from table1 group by id