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