Hi

I was searching for highest 3 values finding query on forum. All I could found was query using ORDER BY in the INNER SELECT query. However I am on Oracle 8.0.5 where it is not working.
There is an error whenever I put ORDER BY inside INNER SELECT in FROM clause. Is there any other way to that.

I would like to make global query which can be run on any table for a specified column.

Amol

PS The query below gives error in my Oracle

select sal
from (select sal from emp order by sal desc)
where rownum <= 3;

from (select sal from emp order by sal desc)
*
ERROR at line 2:
ORA-00907: missing right parenthesis