Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> please help with SQL query...
I need some help to figure out how to do this query...
Here is the data:
OriginalMessageID MessageID(PK) ExecDate 1 1234 10:20 1 5FE2 10:55 1 EA33 10:50 2 4667 11:10 2 98EA 10:13
Now I need the MessageID for the latest record for each OriginalMessageID, so the result would be:
MessageID(PK)
5FE2
4667
What would the SQL SELECT look like to get this result....
Thanks
Massimo
Received on Thu Aug 24 2000 - 12:11:24 CDT
![]() |
![]() |