Query to fetch 100 records in 1000

I have more than 10000 records in database , due to size limit , i can not fetch all records at once.Therefore i just wanted to know is there any way that i can give size limit and get records step by step. Like , first time i would get 100 records then another 100 and so on.