用SQL写出分页查询

方法1：

适用于 SQL Server 2000/2005

SELECT TOP 页大小 *

FROM table1

WHERE id NOT IN

          (

          SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id

          )

ORDER BY id

方法2：

WHERE id >

          SELECT ISNULL(MAX(id),0)

          FROM

                (

                SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id

                ) A

方法3：

适用于 SQL Server 2005

FROM

        (

        SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1

        ) A

WHERE RowNumber > 页大小*(页数-1)