Re: How to get latest date

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Fri, 15 Jan 1999 15:10:10 GMT
Message-ID: <369f5a40.477583588@news.cyberus.ca>

Use the max or min functions...
adrianh_at_globalnet.co.uk (Adrian Harrison) wrote:

>This is probably a very simple question but I can't work out how to do it!
>
>I have to write a sql statement that returns just one record from a table based on a date field
>
>I need to be able to pick the latest/earliest date!
>
>e.g
>
> 15-Jan-99
> 31-Jan-99
> 01-Jan-99
>
>How can I just return 31-Jan-99 or 01-Jan-99?
>
>Thanks
>
>Adrian harrison
>

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Fri Jan 15 1999 - 09:10:10 CST