数据处理之行转列

SELECT LISTAGG(DISTINCT(SLAB_LEN),',') WITHIN GROUP(ORDER BY SLAB_LEN),PONO FROM (select SLAB_LEN,PONO from TPSSMMABW03 GROUP BY SLAB_LEN,PONO) GROUP BY PONO

实现了根据PONO号汇总板坯长度，同PONO多定尺会将定尺用逗号拼接