Re: how can i find out the second maximum value from a table by sql
From: Ken Papai <ken_at_kenpapai.com>
Date: Thu, 14 Feb 2002 21:19:29 GMT
Message-ID: <BRVa8.13713$kt5.29586_at_rwcrnsc52.ops.asp.att.net>
Date: Thu, 14 Feb 2002 21:19:29 GMT
Message-ID: <BRVa8.13713$kt5.29586_at_rwcrnsc52.ops.asp.att.net>
"keith" <prk25_at_yahoo.com> wrote ...
> sohelcsc_at_yahoo.com (Leader) asked:
> > 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);
PERFECT and best answer by Keith.
Ken Received on Thu Feb 14 2002 - 22:19:29 CET