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
标签：LISTAGG,WITHIN,Test,SID,Oracle,GROUP,ID From： https://www.cnblogs.com/zhan-shuai/p/17491675.html