Scenario : How can I retrieve only the first n rows, second n rows of a database using a particular WHERE clause ?

Example

If a SELECT typically returns a 1000 rows, how do first retrieve the 100 rows, then go back and retrieve the next 100 rows and so on.

Use the Statement.setFetchSize method to indicate the size of each database fetch.

Note that this method is only available in the Java 2 platform.

For JDK 1.1.X and JDK 1.0.X, no standardized way of setting the fetch size exists.