当你的表A中有name,scole两列,数据如下
name scole
a 1
a 2
b 1
b 2
想让数据以 a|1|2 , b|1|2格式显示可使用listagg()
1、使用listagg() + group by
select name,listagg(scole,'|') within GROUP (order by name) as scoles from A group by name;
2、使用listagg() + over(partition by ?)
select name listagg(scole,'|') within Group(order by name) over(partition by name) C from A;