top keyword in oracle 9i

Question

what is the format for using top keyword in oracle 9i? i have to retreive top 10 records..

Answer 1

Use the RANK function as in...

select
   *
from
   (select empno,sal,rank()
    over (order by sal desc ) rnk
    from emp)
where rnk <= 5;

query was taken from here

Answer 2

You can use the rownum keyword

SELECT * FROM (your ordered query)  WHERE ROWNUM <= 10

Answer 3

select column1,column2 from tbl1 where rownum<=10