Re: how can i find out the second maximum value from a table by sql
From: George D. Benetos <gbenet_at_intranet.gr>
Date: Thu, 14 Feb 2002 16:21:10 +0200
Message-ID: <a4gh63$8i6$1_at_newsserv.intranet.gr>
Date: Thu, 14 Feb 2002 16:21:10 +0200
Message-ID: <a4gh63$8i6$1_at_newsserv.intranet.gr>
select your column from
(
select your column,rownum test from perf networkelements order by
your column desc
)
where test =2
George D. Benetos
Electrical & Computer Engineer N.T.U.A
--
Received on Thu Feb 14 2002 - 15:21:10 CET