e-
From: Alain Fontaine [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 11:01 AM
To: Solsberry, Glendon; [EMAIL PROTECTED]
Subject: RE: MIN/MAX Date Field
How about:
select some_data from the_table order by the_date ASC limit 1
?
-Message d'origine-
De : Solsberry, G
Solsberry, Glendon wrote:
> Is there a way to select some data from a table where the date field is
> the MIN() of that date column? Aka, if I have 100 rows of data, and the
> MIN() date is 1/1/2000, then I want to select the data that is from
> 1/1/2000. Can this be done without doing a multi-t
How about:
select some_data from the_table order by the_date ASC limit 1
?
-Message d'origine-
De : Solsberry, Glendon [mailto:[EMAIL PROTECTED]]
Envoye : vendredi 5 juillet 2002 16:52
A : [EMAIL PROTECTED]
Objet : MIN/MAX Date Field
Is there a way to select some data from a table whe
