Aggregating Strings in DB2

db2-aggregate-string.sql

-- Based on https://www.ibm.com/developerworks/community/blogs/SQLTips4DB2LUW/entry/aggregating_strings42?lang=en

SELECT 
  dept,
  SUBSTR(XMLCAST(XMLGROUP(',' || name AS a
                          ORDER BY name)
                 AS VARCHAR(60)), 2) AS Names,
 avg(salary) as avgsal
 FROM emp 
 GROUP BY dept;