select 表.ID
listagg(表.Name, ',') within GROUP(order by 表.Name) as name
from 表
listagg(表.Name, ',') within GROUP(order by 表.Name) as name
from 表
group by 表.ID
结果为:ID NAME
1 xx,xx
2 xx,xx
group by 表.ID
结果为:ID NAME
1 xx,xx
2 xx,xx