普通方式
select listagg(a.buguid,',') within group (order by a.create_time desc) from t_tar a where 1=1
分组方式
select listagg(a.buguid,',') within group (order by a.create_time desc) from t_tar a where 1=1 group by a.buguid;
普通方式
select listagg(a.buguid,',') within group (order by a.create_time desc) from t_tar a where 1=1
分组方式
select listagg(a.buguid,',') within group (order by a.create_time desc) from t_tar a where 1=1 group by a.buguid;
转载于:https://my.oschina.net/u/2446173/blog/2997084