File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Getting the last three added rows to a table HSQLDB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Getting the last three added rows to a table HSQLDB" Watch "Getting the last three added rows to a table HSQLDB" New topic
Author

Getting the last three added rows to a table HSQLDB

Sammy Bill
Ranch Hand

Joined: Dec 29, 2008
Posts: 96
Hello,

How can i retrieve the last three added rows to a table?
I m not using any auto-increment id.

Thanks
Oussama
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

Not reliably. You can hope they are stored in that order in the table, but that isn't guaranteed.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Getting the last three added rows to a table HSQLDB
 
Similar Threads
scroll bar issue
instaceof operator
Question about deleting rows from a table
Problem in setting column width..
Dynamic checkbox