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!

select bottom 50,000+ records

722955Nov 5 2009 — edited Nov 5 2009

I want to select the bottom 50,000+ records from a table with 65,000+ records in it. I have used the following:

SELECT *
FROM (select * from ACTIONDATA_TWO) suppliers2
WHERE ROWNUM > 10000

but it doesn't return even one record. How should I go about doing this?

Thanks!!!!

This post has been answered by Frank Kulash on Nov 5 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2009

Added on Nov 5 2009

4 comments

1,593 views