1.oracle
select id ,wmsys.wm_concat(name) from t group by id;
2.DB2
SELECT [分组的字段],LISTAGG([需要聚合的字段名], ',') WITHIN GROUP(ORDER BY [排序的字段名]) AS employees FROM [表名] GROUP BY [分组的字段名] ;
SELECT MONITORTIME,HBJ,REGIONNAME,LISTAGG(NAME, ',') WITHIN GROUP(ORDER BY MONITORTIME desc) AS employees
FROM TENV.T_AIR_MESSAGE_HISTORY GROUP BY MONITORTIME,HBJ,REGIONNAME