How to retieve top five most records from a table

[beginnerboy]

Hi,
I need to retrive only top five sales agents from sales table .Sales table contains sales agent's name and amount of sales for each agent in addition to other fields.Can we do that without writing procedure?

Thanks in advance

 

[sem]

select * from
(select * from sales order by amount desc)
where rownum<=5

Regards, Dima

http://seminihin.narod.ru