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!

Return last 100 rows?

3073May 15 2003 — edited Aug 6 2003

Hi,
I am wondering if there is any new function/clause(other then order by) to use in sql statement to return the specific number of rows from the end of the table (e.g. last 100 rows). I need something to be faster the order by.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2003

Added on May 15 2003

9 comments

579 views