Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Selecting 2nd Largest Value

Selecting 2nd Largest Value

From: John D. Boshears <jbosh_at_purdue.edu>
Date: Mon, 21 Jan 2002 13:17:32 -0500
Message-ID: <Pine.SOL.4.43.0201211314430.8565-100000@herald.cc.purdue.edu> 





How would I go about selecting the second largest value from a table? Not
the second in order, but the second largest. I know in Access you could
combine TOP and MIN functions, but I can't find a function similar to TOP
in Oracle.



thanks.



John
Received on Mon Jan 21 2002 - 12:17:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US