TO DISPLAY 5 TO 7 ROWS FROM A TABLE

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 854
select ename from emp
where rowid in(select rowid from emp where rownum<=7
minus
select rowid from emp where rownum<5)

Comments or Responses

Login to post response