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 -> Tricky SQL Problem

Tricky SQL Problem

From: Matt Randle <matt_at_imat.demon.co.uk>
Date: Fri, 30 Apr 1999 12:22:56 +0100
Message-ID: <925471736.21781.0.nnrp-07.d4e48d0d@news.demon.co.uk>


We have a table that is keyed on a unique ID + a Date Time value. Using Oracle SQL is there any way of finding the most recent assignments by ID.

For example, if the table was populated as follows (British dates),

ID Date Time + Additional Columns

1              1/1/99
1              5/3/99
1              6/4/99
2              4/4/99
2              28/5/99
3              1/4/99
4              27/2/99
4              5/5/99
4              9/8/99

The result set should be,

ID Date Time + Additional Columns

1              6/4/99
2              28/5/99
3              1/4/99
4              9/8/99

Thanks in advance,

Matt. Received on Fri Apr 30 1999 - 06:22:56 CDT

Original text of this message

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