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

Home -> Community -> Usenet -> c.d.o.misc -> Re: select statment with between date parameters

Re: select statment with between date parameters

From: Keith Jamieson <pdkj02_at_email.mot.com>
Date: Mon, 24 May 1999 13:16:36 +0100
Message-ID: <37494323.D5672AB5@email.mot.com>


Select min(date),max(date)
from table_name

Chistine Do wrote:

> Hello All,
> I would like to know how to create a select statement using the greatest and
> least to select the date parameters (ex. 05-aug-98 to 05-apr-99) without
> using the where clause.
>
> Please advice!
>
> Thanks
> Christine
> email: christine_at_idec.com
Received on Mon May 24 1999 - 07:16:36 CDT

Original text of this message

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