用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)