Query use rownum pseudo column
Select * from (select rownum rn, empno from emp where rownum & lt; 9) where rn & gt; 4.

CodePudding user response:

It is ok to write a select use rownum between o