Re: how can i find out the second maximum value from a table by sql
From: keith <prk25_at_yahoo.com>
Date: 14 Feb 2002 07:08:15 -0800
Message-ID: <adbca63f.0202140708.1a5ca777_at_posting.google.com>
Date: 14 Feb 2002 07:08:15 -0800
Message-ID: <adbca63f.0202140708.1a5ca777_at_posting.google.com>
sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0202132336.4191d0e6_at_posting.google.com>...
> Hi all,
> How can i find out the second maximum value from a table by sql.
>
>
> thanks
> Hoque
select max(col)
from table
where col !=
(select max(col)
from table)
Keith Received on Thu Feb 14 2002 - 16:08:15 CET