Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to get latest date

How to get latest date

From: Adrian Harrison <adrianh_at_globalnet.co.uk>
Date: Fri, 15 Jan 1999 11:21:01 GMT
Message-ID: <369f249a.2315860@news.globalnet.co.uk> 





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:21:01 CST












Original text of this message













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