How to retrive 1000 rows at a time where table consists of 10000 rows.

I am trying to retrive 1000 rows at a time (to be displayed)form the differnet tables where actual data consists of 10000 rows.SO guys does any one done any work around for this .please let me know