1 Reply Latest reply on Oct 11, 2006 11:52 PM by Newsgroup_User

    How to Display certain (20) rows per page

    sudhakar_g
      Hi,

      I want to display 20 results from a resultset and give the options for next and previous pages with 20 results in each page.I am using asp and sql server.

      I know that MySQL has feature LIMIT OFFSET, but in SQL SERVER - TOP & SET ROWCOUNT commands only displays only the top rows,I mean 1-20 in the first page can be displayed but in the next page how to display rows from 21-40? I am really confused??? Looks like a simple thing but I couldnot find solution for it.I will be very thank ful to anyone who can help me with this.

      Regards
      Sudhakar