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

Home -> Community -> Usenet -> c.d.o.server -> Re: A SQL question, please help...

Re: A SQL question, please help...

From: James A. Johnson <nimbus3_at_bellsouth.net>
Date: 1998/12/08
Message-ID: <366C8C06.DD452A02@bellsouth.net>#1/1

yes....use the substr function in oracle.... substr(<field>, 1, 2), substr....

Jimmy wrote:

> Hello all,
>
> I have the following rows in table A:
>
> ID date A1 A2 A3
> 1 01-Jan-98 10
> 2 01-Jan-98 10 11
> 3 01-Jan-98 12
> 4 01-Feb-98 20 21
> 5 01-Feb-98 20 22
> 6 01-Feb-98
>
> Field value is the same with the same date. The table, in fact, has
> problem of splitting the same date row into different rows. So I want to
> combine the same date row as the following table:
>
> ID date A1 A2 A3
> 1 01-Jan-98 10 11 12
> 4 01-Feb-98 20 21 22
>
> i.e. combine the rows with the same date, use the smallest ID among the
> same date rows. The field value may be character.
>
> Can I do that by using SQL statement?
>
> Thanks,
> Jimmy
Received on Tue Dec 08 1998 - 00:00:00 CST

Original text of this message

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