Hi, is there any clause like LIMIT (I know it from mysql) in Oracle?
thx in advance, T.H.
You can use rownum
SELECT Empno, Ename, Job, Mgr, Hiredate, Sal FROM Emp WHERE ROWNUM < 6 ORDER BY Sal
Thx Lars, it worked perfectly!
