jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes records between sequence numbers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "records between sequence numbers" Watch "records between sequence numbers" New topic

records between sequence numbers

sumanth kumar

Joined: Jul 29, 2005
Posts: 22
We have thousands of records with sequence numbers in the oracle database, we need to retrieve a number of records between two sequence numbers, i.e. to retrieve records between 100 and 200 sequence numbers. Could some one help me to find a query to fetch records.
Carol Enderlin
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
try "between", or use >= and <=

google oracle between
I agree. Here's the link: http://aspose.com/file-tools
subject: records between sequence numbers
It's not a secret anymore!