Re: Column aggregating for text columns

From: Bob Hairgrove <>
Date: Wed, 22 May 2002 20:10:58 GMT
Message-ID: <>

On Wed, 22 May 2002 01:21:58 GMT, "Sirin Venigalla" <> wrote:

>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

DB2 should support the newer SQL "LIST" function.

Bob Hairgrove Received on Wed May 22 2002 - 22:10:58 CEST

Original text of this message