Re: select statment with between date parameters

select MAX(datefield) from tablename;
select MIN(datefield) from tablename;

(why can't you use a WHERE clause?)

Chistine Do wrote in message ...
>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 Fri May 21 1999 - 22:41:31 CDT