17,140
社区成员




select id,wm_concat(tb.info) info,wm_concat(tb.price) price
from tb
group by id
--确实如此,使用wm_concat也一样,如果每次聚合1列就没有问题
SELECT a.info, b.price
FROM (SELECT id, connstrsum(info) info FROM product GROUP BY id) a,
(SELECT id, connstrsum(price) price FROM product GROUP BY id) b
WHERE a.id = b.id;