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多定尺会将定尺用逗号拼接
数据处理之行转列
原文：https://www.cnblogs.com/yjy1412/p/15005495.html
