If I understand correctly, what you want to do is called resultset paging.
You can find much information on this topic in this
thread An exhaustive review of the topic with implementation is given in
this article at serverside.com
[ September 09, 2002: Message edited by: Tanel Alumae ]