Re: Newbie Q - maximum value of a column

From: Roberto <rprendin_at_magi.com>
Date: 1996/10/18
Message-ID: <546ovd$o13_at_news.istar.ca>#1/1


If I understand your question, you're looking for the largest value in that column:

select max(key) from (TABLE NAME);

Cheers, Roberto

kmku_at_hkusua.hku.hk (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~}
>*********************************************************************
>
Received on Fri Oct 18 1996 - 00:00:00 CEST

Original text of this message