Re: A SQL question, please help...

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 CET