aspose 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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 26173
    
  66

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://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Getting the last three added rows to a table HSQLDB
 
Similar Threads
Dynamic checkbox
instaceof operator
scroll bar issue
Problem in setting column width..
Question about deleting rows from a table