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,* FROMtable

1

       ) A

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