Active Directory, AS/400, Business Intelligence, Career Development, CIO, Cisco, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing Technology, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP VIEW ALL TAGS
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, Fld3Thanks! We'll email you
when relevant content is
added and updated.