Search This Blog

Friday, September 7, 2012

Query to display the data which has rownum as 5




select * from emp
where rowid=(select rowid from emp where rownum<=5
minus
select rowid from emp where rownum<5)

No comments:

Post a Comment