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