分组后合并字段方法

select  [分组的字段],ltrim(max(sys_connect_by_path([要合并的字段], ',')), ',') [要合并的字段]
 from (
 select [分组的字段],[要合并的字段],row_number()over(partition by [分组的字段] order by [要合并的字段]) rn
 from 表名)
 start with rn=1
 connect by prior rn=rn-1 and prior [分组的字段]=[分组的字段]
group by [分组的字段]
order by [分组的字段];

转载于:https://www.cnblogs.com/nb2sfc/p/3459779.html