sqlserver2000数据库分页查询

sqlserver2000数据库分页查询[根据网上搜索到得sql修改] ?

1 2 3 4 5 6 7 8 9

10

11

12

13

14

15 SELECT TOP 页大小 *

FROM TestTable

WHERE (ID >

(SELECT case when count(0) < 页大小 then 0 else MAX(id) end FROM (SELECT TOP 页大小*(页数-1) id

FROM 表

ORDER BY id) AS T))

ORDER BY ID