iS THERE A top(X) FUNCTION IN oRACLE?

[DBAtrix]

From MetaLink Note:47915.1

With Oracle8i, the distinct clause is no longer necessary since it is now
possible to use an order by directly in an in-line view. Thus the above two
select statements become:

select ename, empno, deptno
from (select deptno, ename, empno from emp ORDER BY deptno, ename)
where rownum <= 5;

D.