Server 2000/2005 分页

方法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：

适用于 SQL Server 2000/2005

SELECT TOP 页大小 *

FROM table1

WHERE id >

          (

          SELECT ISNULL(MAX(id),0)  

          FROM  

                (

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

                ) A

          )

ORDER BY id  

方法3：

适用于 SQL Server 2005

SELECT TOP 页大小 *  

FROM  

        (

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

1

        ) A

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