SQL 分页语句

 

方法一

SELECT TOP 页大小*
FROM table1
WHERE id NOT IN
          (
          SELECTTOP 页大小*(页数-1) id FROM table1ORDER BY id
          )
ORDER BY id

 

方法二

SELECT TOP 页大小*
FROM table1
WHERE id >
          (
          SELECTISNULL(MAX(id),0)
          FROM
                (
                SELECTTOP 页大小*(页数-1) id FROM table1ORDER BY id
) A
          )
ORDER BY id

 

方法三

SELECT TOP 页大小*
FROM
        (
        SELECT ROW_NUMBER()OVER (ORDERBY id) AS RowNumber,*FROM table1
        ) A
WHERE RowNumber> 页大小*(页数-1)