Re: Newbie Q - maximum value of a column

From: Marek Wiechula and Sheila Plant <sparemgw_at_batelco.com.bh>
Date: 1996/10/17
Message-ID: <3266BCE9.3F1F_at_batelco.com.bh>#1/1


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~}
> *********************************************************************
>
I assume you mean the maximum value already assigned....

Select max(key) from <table_name>;

Should do it...

Marek Received on Thu Oct 17 1996 - 00:00:00 CEST

Original text of this message