摘要：select 外键ID, ltrim(max(sys_connect_by_path(name,',')),',') temp_name from (select 外键ID,name,row_number() over(partition by 外键IDorder by 外键ID, name) rankfrom table) start with rank=1connect by rank - 1 = prior rankand 外键ID= prior 外键IDgroup by 外键ID合并之前数据如下：外键ID name001 AAA001 BBB001 CC 阅读全文