--oracle分组之后将结果组装为一个字符串 逗号分隔 输出
SELECT id,
listagg(to_char(name), ',') within group(order by id) AS names
FROM table
GROUP BY id
查询结果如下:
--oracle分组之后将结果组装为一个字符串 逗号分隔 输出
SELECT id,
listagg(to_char(name), ',') within group(order by id) AS names
FROM table
GROUP BY id
查询结果如下: