Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why rownum >5 return no rows selected

800528Mar 5 2012 — edited Mar 5 2012
hi

i want to know why rownum >5 .. is give no rows selected

eg

select * from emp where rownum>5;

.....
This post has been answered by Paul Horth on Mar 5 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2012
Added on Mar 5 2012
3 comments
5,842 views