+ Reply to Thread
Results 1 to 2 of 2

Fetching 1000 rows at a time

  1. Fetching 1000 rows at a time

    hello all

    I need a sql statment that will fetch 1000 rows at a time

    for example i have got a table called customer which consist of 7500 rows
    in my first fetch i need

    1 fetch -- 0 -1000 rows
    2 fetch -- 1001 -2000 rows
    1 fetch -- 2001 -3000 rows
    1 fetch -- 3001 -4000 rows
    so no

    I am really dying to have a sql statement to fetch like this manner...

    i know using TOP keyword to fetch first 1000 but how can i fetch the next
    1000 .

    Thanks in advance

    /Prasha



  2. Re: Fetching 1000 rows at a time

    Look for serverside paging in google, there are tons of hits out there,

    HTH, jens Suessmeyer.


+ Reply to Thread