How can I retrieve only the first n rows, second n rows of a database (using a particular WHERE clause ? )
For 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 ?
Suggestions or comments are welcome
posted 4 years ago
If you are using JPA, you can use the firstResult and maxResults properties on the Query.