Re: how can i find out the second maximum value from a table by sql
From: Bricklen Anderson <bricklen13_at_hotmail.com>
Date: 14 Feb 2002 07:38:17 -0800
Message-ID: <b416ca2d.0202140738.18b38bf_at_posting.google.com>
Date: 14 Feb 2002 07:38:17 -0800
Message-ID: <b416ca2d.0202140738.18b38bf_at_posting.google.com>
simply enough:
select max(column_containing_the_value) from your_table_name;
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
Received on Thu Feb 14 2002 - 16:38:17 CET