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_at_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
Date: Wed, 22 May 2002 01:21:58 GMT
Message-ID: <WoCG8.90740$2G1.31110535_at_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 Wed May 22 2002 - 03:21:58 CEST