| Author |
records between sequence numbers
|
sumanth kumar
Greenhorn
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
drifter
Ranch Hand
Joined: Oct 10, 2000
Posts: 1348
|
|
try "between", or use >= and <=
google oracle between
|
|
 |
|
|
subject: records between sequence numbers
|
|
|
0
