Re: Help!Select latest date.

From: Rudy Zung <zungr_at_prograph-inc.com>
Date: Fri, 19 Mar 1999 11:08:04 -0500
Message-ID: <7ctsnu$5mg$1@mailhost.prograph-inc.com>

select

t.*
from

tableName t,
(select max(myDate) m from tableName) v where

t.myDate = v.myDate

...Ru

Prizant Lev A. wrote in message
<0324E65CE2ABD11195C10000F878B46339DD04_at_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 - 10:08:04 CST