Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Column aggregating for text columns

Re: Column aggregating for text columns

From: Tokunaga T. <tonkuma_at_jp.ibm.com>
Date: 22 May 2002 03:44:07 -0700
Message-ID: <8156d9ae.0205220244.6f3d9269@posting.google.com>


"Sirin Venigalla" <a_at_abc.com> wrote in message news:<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

My question is how to map value 'abc' to column value1, value 'cde' to column value2 and value 'xxx' to column value3. If you could clarify that point, it would be not so difficult to solve this problem. Received on Wed May 22 2002 - 05:44:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US