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

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

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

Original text of this message

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