SQL Server 2000 分页查询

分别用 NOT IN 和 NOT EXISTS 实现：

NOT IN：

select TOP 10 * FROM student WHERE id not in (SELECT TOP (2*10) id FROM student)

NOT EXISTS：

SELECT TOP (10) * FROM student AS s1 WHERE NOT EXISTS (
  SELECT * FROM (
    SELECT TOP (2*10) * FROM student 
  ) AS s2 WHERE s1.id = s2.id
)

第一个TOP后跟的数值为每页条数，第二个TOP后跟的数值为从哪里开始往后查（页码 * 每页条数）