请问我怎么能在Oracle中将多行数据整合到一行显示

Question

这是初始的样式

现在我想转换成下面的格式

请问大家，我该怎么做啊

Answer 1

只能这样了：
select id ,listagg( name, ',' ) within group ( order by id ) as Name,listagg( num, ',' ) within group ( order by id ) as Num,listagg( price, ',' ) within group ( order by id ) as Price
from TABLE_NAME
GROUP BY id;
得到格式：id name num price
1 apple,orange,pear,banana 1,3,3,2 2,2,1,2