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 -> Help!Select latest date.

Help!Select latest date.

From: Prizant Lev A. <PrizantLA_at_BWSC.ORG>
Date: Fri, 19 Mar 1999 09:34:16 -0500
Message-ID: <0324E65CE2ABD11195C10000F878B46339DD04@ntsv2.bwsc.org>


Hi,

I'm trying to select a record or records from a recordset with the latest date.
For example if there are 4 records with date fields:

01-MAR-1999
02-MAR-1999
05-MAR-1999
05-MAR-1999

then I want to select all records where dates are '05-MAR-1999'.

Thanks in advance! Received on Fri Mar 19 1999 - 08:34:16 CST

Original text of this message

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