Re: Newbie Q - maximum value of a column

select key
from table
where rownum <=1
order by key desc ;

hope this helps you.

Imtiaz Ahmed
E-mail imtiaz_at_qatar.net.qa

Kevin Loney <"75663,327"_at_compuserve.com> wrote in article <3267D73C.2ED_at_compuserve.com>...
> Ku Kam Ming wrote:
> >
> > A column named 'key NUMBER(6)' is used as primary key. I would like to
> > know the simplest way to get the maximum value of the column 'key'.
> >
> >
>
> select MAX(key_col)
> from table;
>
  Received on Sun Oct 20 1996 - 00:00:00 CEST