Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL question
Re:
>Hi! I would appreciate help on the following SQL question. I have a
>table that contains data such as:
>ID Name Value1 Value2 Systime
>---- ------ ------ ------ -------
>1 AAA 10 25 01-Jan-1996
>1 BBB 100 250 01-Dec-1995
>1 AAA 20 50 10-Jan-1996
>1 BBB 200 20 05-Jan-1996
>1 MMM 250 240 11-Jan-1996
>etc.
>
>I would like to write a SQL statement to return the name, value1, value2
>and systime where the systime is the most recent for a distinct name. For
>instance, the output would give me the row with name AAA and systime
>10-Jan-1996 and
>
HTH, Tom
Rockville, MD twheltle_at_us.netReceived on Fri Jan 12 1996 - 17:07:22 CST
![]() |
![]() |