Access分页语句

一、双TOP法高效率的Access分页的SQL语句，语法格式：

SELECT * FROM 
    (SELECT TOP "&pagesize&" * FROM 
    (SELECT TOP "&page*pagesize&" 字段 FROM 表 ORDER BY id DESC) 
    ORDER BY id) 
    ORDER BY id DESC

最后一页要注意：

   //如果是最后一页了，要重新计算pageSize=maxPage*pageSize-totalcount
            if (pageIndex == maxPage)
            {
                pageSize = (maxPage * pageSize - totalCount)==0? pageSize : (maxPage * pageSize - totalCount);
            }

 

二、扩展带条件的

SELECT * FROM 
(SELECT TOP 2 * FROM 
(SELECT TOP 2 id FROM SoftwareAuthorizeInfo where id=3  ORDER BY id DESC) 

ORDER BY id) 
ORDER BY id DESC 

 

转载于:https://www.cnblogs.com/25miao/p/11320125.html