sql分页

select top 10 * from product_main
where id>all(select top 10 id from product_main order by id)
order by id

---------------------------------------------------------------------------------------------------------------------------------------------

SELECT TOP 10 *
FROM product_main
WHERE (ID >
          (SELECT MAX(id)
         FROM (SELECT TOP 20 id
                 FROM product_main
                 ORDER BY id) AS T))
ORDER BY ID

---------------------------------------------------------------------------------------------------------------------------------------------

SELECT TOP 页大小 *
FROM TestTable
WHERE (ID >
          (SELECT MAX(id)
         FROM (SELECT TOP 页大小*页数 id
                 FROM 表
                 ORDER BY id) AS T))
ORDER BY ID