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
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'.
>**********************************************************************
>Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
>*********************************************************************
>
Received on Fri Oct 18 1996 - 00:00:00 CEST