Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get latest date
Try select min(date_column), max(date_column) from table
And look up aggregate / group queries in the Oracle manuals.
JR
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
>
Received on Fri Jan 15 1999 - 05:59:05 CST