Re: Newbie Q - maximum value of a column

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'.
>
> Thanks in advance,
> --
> **********************************************************************
> Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
> *********************************************************************
> Try

SELECT MAX(KeyColumnName) FROM KeyTableName

Best wishes

Bob Acker
Programming Resources, Inc.
Ft. Lauderdale, FL Received on Tue Oct 22 1996 - 00:00:00 CEST