Currently when I issue a conditional select statement to a table it retrieves all the rows satisfying the condition, which is normal. I am intrested in knowing, say if the condition returns 100 rows, i would like to retrieve only 10 records at a time, display and if user wants more and fetch the next 10 and continue till no more retrieval is possible. The normal select goes through till EOF. How do I force the select to stop a point and continue from there for the next batch of fetch. Is there any mechanisam in SQL to do this. Every batch of retrieval should be from the table. This problem has arised because we intend not to maintain the state of the retrieval (either in result set) in server.