1：SELECT ID, SID FROM Test WHERE ID ='001'
2：SELECT ID,LISTAGG(SID, ',') WITHIN GROUP (ORDER BY SID) AS SID_LIST
FROM Test WHERE ID ='001'
group by ID
ORACLE 分组 将多条合并一条
发布时间 2023-06-19 17:24:05作者: 似曾相识燕归来
1：SELECT ID, SID FROM Test WHERE ID ='001'
2：SELECT ID,LISTAGG(SID, ',') WITHIN GROUP (ORDER BY SID) AS SID_LIST
FROM Test WHERE ID ='001'
group by ID