Oracle 列转行
转为
SELECT aac002,aac003,aaa001,bbb001,cf_type,bd_type, LISTAGG(aae003, ',') WITHIN GROUP (ORDER BY aac002) AS aae003
FROM Data_dycflq_2021
GROUP BY aac002,aac003,aaa001,bbb001,cf_type,bd_type
LISTAGG()函数
2023-08-01 09:31:34
Oracle 列转行
转为
SELECT aac002,aac003,aaa001,bbb001,cf_type,bd_type, LISTAGG(aae003, ',') WITHIN GROUP (ORDER BY aac002) AS aae003
FROM Data_dycflq_2021
GROUP BY aac002,aac003,aaa001,bbb001,cf_type,bd_type
LISTAGG()函数