原始数据:
方法:调用listagg函数
select t.id, t.name, listagg(t.subject, ',') within group(order by t.id)
from test1 t
group by t.id, t.name
原始数据:
方法:调用listagg函数
select t.id, t.name, listagg(t.subject, ',') within group(order by t.id)
from test1 t
group by t.id, t.name