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 -> Highest Values II

Highest Values II

From: <rpereira_at_my-deja.com>
Date: Thu, 27 May 1999 19:26:49 GMT
Message-ID: <7ik69k$5ci$1@nnrp1.deja.com>


The following solution

select *
  from (select *

        from mytable
        where <wherecondition>
        order by <the column which holds the values> desc)
where rownum <= 50

to find the 50's highest values from a number column in a table does not work in Oracle 7.3 (that I had)

Please help me to find a way to do this

Thanks.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu May 27 1999 - 14:26:49 CDT

Original text of this message

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