Oracle Database Discussions

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!

last ten rows of table

user511621Aug 6 2008 — edited Sep 16 2008

hi

if my table has 100 rows and i want to see first 10 rows

i can do select * from table where rownum < 11

but how can i fatch only last 10 rows from my table ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2008

Added on Aug 6 2008

#general-database-discussions

17 comments

2,059 views