Skip to Main Content

Java Database Connectivity (JDBC)

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!

Retrieve the Last n Records from an Oracle database

843859Aug 18 2005 — edited Nov 20 2014
Please help me with how to retrieve the last n (say, 4) records from an Oracle database (i.e. the last 4 records).

The statement can be:

SELECT * from TableName ????;

I put * there because all columns of every single record will be needed.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2008
Added on Aug 18 2005
21 comments
300 views