Suppose the SELECT returns 1000 rows, then how to retrieve the first 100 rows, then go back and retrieve the next 100 rows?

Suppose the SELECT returns 1000 rows, then how to retrieve the first 1

1.	Suppose the SELECT returns 1000 rows, then how to retrieve the first 100 rows, then go back and retrieve the next 100 rows?
Answer» Use the Statement.setFetchSize method to indicate the size of each database fetch.