I am using ORACLE 7.3 .

I have one table "employee" with a column "sal" .
I have inserted the data into the sal in random order.
Now I want to retrive the rows from that table who draw the maximum salary. (sal).

That is first 5 records after the list is selected by using "order by desc " clause.

I want to use single SQL statement.

some thing like this algorithm.

select first 5 records from ("select sal from employee order by sal desc " )

I tried to use rownum, count() etc. but in fail.

I dont want to use Foxpro .


--Satya