Column aggregating for text columns

From: Sirin Venigalla <a_at_abc.com>
Date: Wed, 22 May 2002 01:21:58 GMT
Message-ID: <WoCG8.90740$2G1.31110535@typhoon.nyroc.rr.com>

I found this interesting question on another forum. I am going to work on it, but if anyone has a solution please post it.

---

How do i convert this data in a table
id value
123 abc
123 cde
123 xxx
to a query output

id value1 value2 value3
123 abc cde xxx

I am using DB2 UDB 7.X Received on Tue May 21 2002 - 20:21:58 CDT