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~}
> *********************************************************************
>

select max(key) from table_name;

-- 
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo