access分页sql

麻烦高手给写了access分页sql

---

string strPageSQL1 = "select top " + pageSize + " * from 表名 where 查询条件 order by id";
string strPageSQL2 = "select top " + pageSize + " * from 表名 where 查询条件 and id > (select max(id) from (select top " + pageSize * (pageIndex - 1) + " id from 表名 where 查询条件 order by id) as T) order by id";

第一页数据用第一句，第二页以后用第二句。
pageSize是每页的记录数
pageIndex是页码

---

一、Top

select * from Products where productid in
  ( select top 15 productid from
    ( select top 1499985 productname,productid from Products
        order by productid ) as t
      order by t.productid desc )

order by productid

二、Max

select top 15 * from Products
where productid>=
  (SELECT max(productid ) from
    (select top 2399986 productid from Products order by productid ) as t )

order by productid

---

引用

一、Top

select * from Products where productid in
  ( select top 15 productid from
    ( select top 1499985 productname,productid from Products
        order by productid ) as t
      order by t.productid desc )

order by productid

二、Max

se