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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: tricky SQL question!

Re: tricky SQL question!

From: VC <boston103_at_hotmail.com>
Date: Fri, 06 Feb 2004 02:05:28 GMT
Message-ID: <IDCUb.184981$sv6.958378@attbi_s52>

Well, it's rather trivial:

select * from t1 x
where a=(select max(a) from t1 where b=x.b)

VC

> Oracle 9iR2
>
> I have a table:
>
> SQL> select * from test;
>
> A B C
> ------------------- ---------- ----------
> 01/01/2004 10:00:00 1 1
> 01/01/2004 11:00:00 1 2
> 01/01/2004 11:00:00 2 3
> 01/01/2004 13:00:00 2 4
> 01/01/2004 12:00:00 2 5
>
> For every different B value, I want to see the max A value and the
> corresponding C value. In the above example, the result shoud be:
>
> A B C
> ---------------------- ---- ---
> 01/01/2004 11:00:00 1 2
> 01/01/2004 13:00:00 2 4
>
>
> How can I do this in SQL (no PL/SQL or SQL block)?
>
> Thanks a lot!
Received on Thu Feb 05 2004 - 20:05:28 CST

Original text of this message

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