Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: How do I group them together
emdproduct..._at_hotmail.com wrote:
> I am using Oracle 9i.
>
> I have a table with rows like this:
>
> ID value1 value2 value3
> 1 A
> 1 B
> 1 c
> 2 A
> 2 D
> 2 E
>
> I would like the output like this:
> ID value1 value2 value3
> 1 A B c
> 2 D A E
>
> Thanks for your help.
Are you saying you have multiple rows with the same value in column ID, and that the structure of the table is three other columns (besides ID), only one of which will be populated on any given row?
If so, is it too late to reconsider the design.....? Received on Thu Nov 16 2006 - 12:09:45 CST