I have been searching high and low for the query statement to return a certain row in a result set. I have 10000 records in my result set. I want to retrieve only 50 of them at a time for my pagination. Once I am done, I want to retrieve the next 50 and so forward. Is there a simple and direct method to do that?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.