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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!