Home Forums Article Discussions Article Discussions by Author Discuss content posted by Greg Ryan Paginating a SQL query result set RE: Paginating a SQL query result set

  • November 2, 2015 at 6:41 am

    #1837048

    Seems kind of elaborate to replace:

    select top 10 column1, column2, column3 from table where column1 > 99 order by column1

    or

    select top 10 column1, column2, column3 from table where column1 > (99 + (page * 10) )order by column1