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

Home -> Community -> Usenet -> c.d.o.misc -> Newbie question: get last record of a series

Newbie question: get last record of a series

From: Bob McConnell <bob.mcconnell_at_mci.com>
Date: Wed, 21 Apr 1999 17:46:18 GMT
Message-ID: <371E0F8B.1CDBA0FD@mci.com> 





I have a table like this:


field1    field2    field3    date_field

ABCD     0            0        1 apr 99
ABCD     0            0        2 apr 99
ABCD     0            1        1 apr 99
ABCD     1            1        2 apr 99
ABCD     1            1        3 apr 99





I need to return in this case rows 2,3 and 5
the latest date for the unique combinations of field1,2 and 3



tia,


Bob

Received on Wed Apr 21 1999 - 12:46:18 CDT












Original text of this message













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