sql分页查询语句

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

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

SELECT * 
FROM
        (
         SELECT TOP 页大小 * 
         FROM
                 (SELECT TOP (页大小*页数) id FROM table1 ORDER BY id) t1 
         ORDER BY id DESC
         ) t2 
ORDER BY id