Oracle 行转列相对于Sqlserver的实现

Oracle 可以用listagg()来实现行转列select filed,filed,listagg(filed,',') within GROUP (order by filed) as sqrmc from table group by filed实现效果 就是filed以,号分隔开SqlServerSelect filed,COALESCE(substring( ( Select ','+filedFrom table ST1 Where ST1 .filed= ST2 .filedORDER BY ST1 .filedFor XML PATH ('') ), 2, 1000),'')ssFrom table ST2 GROUP BY ST2.UID