retrive first n rows in a query

[Karthika]

In postgres to retrive first n rows we'll use the key word limit. In Oracle how this is possible.

For example in postgres,
select * from emp limit 10 /* retrives first 10 rows of emp */

In oracle this is possible by rownum

select * from emp where rownum <=10.

Is there any other way of doing it.

[skhanal]

rownum works fine. Otherwise you will have to write a complex query.