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 ','+
原创
2017-11-28 13:42:06 ·
206 阅读 ·
0 评论