oracle 多行合并为一行

oracle 多行合并为一行

sys_connect_by_path 

select i,ltrim(max(sys_connect_by_path(a,',')),',') afrom(select i,a,d,min(d) over(partition by i) d_min,(row_number() over(order by i,d))+(dense_rank() over (order by i)) numidfrom t)start with d=d_min connect by numid-1=prior numidgroup by i;

 

wm_sys.wm_concat

select i,wmsys.wm_concat(a) from t group by i;

posted on 2016-10-28 10:26 明净 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/mingjing/p/6006763.html