How can we select multiple column values in a single comma separated column in DB2? I have tried with below query but not working: select Fld1, Fld2, substr(xmlserialize(xmlagg(xmltext(concat(', ', Fld3))) as varchar(1024)),3) from Table1 where Fld1 ='Key1' Group by Fld1, Fld2, Fld3