Re: Column aggregating for text columns
From: Bob Hairgrove <rhairgroveNoSpam_at_Pleasebigfoot.com>
Date: Wed, 22 May 2002 20:10:58 GMT
Message-ID: <3cebfb88.9257201_at_news.ch.kpnqwest.net>
Date: Wed, 22 May 2002 20:10:58 GMT
Message-ID: <3cebfb88.9257201_at_news.ch.kpnqwest.net>
On Wed, 22 May 2002 01:21:58 GMT, "Sirin Venigalla" <a_at_abc.com> 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
rhairgroveNoSpam_at_Pleasebigfoot.com
Received on Wed May 22 2002 - 22:10:58 CEST