how to display 5 to 7 rows from a table?
SELECT enameFROM empWHERE rowid IN (SELECT rowid FROM emp WHERE rownum<=7 MINUS SELECT rowid FROM emp WHERE rownum<5 );