sql server2008 分页语句

SELECT TOP 页大小 *
FROM table1
WHERE id NOT IN
          (
          SELECT TOP （页大小*(页数-1) ）id FROM table1 ORDER BY id
          )

ORDER BY id

例子：

SELECT TOP 5 sc.id,sj.name,sc.problem,sc.option1,option2,option3,option4,answer 
FROM t_singleChoice sc,t_subject sj
WHERE id NOT IN
          (
          SELECT TOP (5*(3-1)) id FROM t_singleChoice ORDER BY id
          )
ORDER BY id