sql 分页

SELECT TOP 10 * FROM Approve
WHERE (ID NOT IN
 (
 SELECT TOP 10*pageindex id FROM Approve
 ORDER BY id
 )
      )
ORDER BY ID

pageindex  为页数