相同行合并,不同行“,”分隔 SELECT"MATNR",--物料号STRING_AGG ("WERKS", ',') AS "WERKS",STRING_AGG ("ZZSYSTEM", ',') AS "ZZSYSTEM",STRING_AGG ("ZZNCCM", ',') AS "ZZNCCM","ATWRT02","ATWRT01"FROM"_SYS_BIC"."BDP_DM.MM.SAM/CAL_BASE_MM_REP_622_LIST"('PLACEHOLDER' = ('$$ip_werks_char$$', '5010,5020,5030,5040,5080,5060,5090,5050'))WHERE"MATNR" = '000000001100020525'GROUP BY"MATNR",--物料号"ATWRT02","ATWRT01"
map函数使用