APEX

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!

ROWNUM with Greater than symbol..!

544878Apr 17 2007 — edited Apr 17 2007

Hi

Can any one explain why ">" greater than operator not working with ROWNUM.

FOR EXAMPLE:
SELECT * FROM EMP where rownum > 2;

But the less than operator is working.
SELECT * FROM EMP where rownum < 2;

Please clarify this.
Thanks in advance.

Regards
Sathya

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2007

Added on Apr 17 2007

#apex-discussions

8 comments

1,112 views