Oracle列转行函数LISTAGG() WITHIN GROUP ()用法

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