Access数据读取分页一
Access数据库不能用ROW_NUMBER()函数,还有except。
故:方法一,升序排序
SELECT TOP 每页数量 * FROM [Position] WHERE [ID] > (SELECT MAX([ID]) FROM (SELECT TOP (当前页数-1)*每页数量 * FROM [Position]
ORDER BY [ID] ASC))
方法二,降序排序
SELECT TOP 每页数量 * FROM [Position] WHERE [ID] < (SELECT MIN([ID]) FROM (SELECT TOP (当前页数-1)*每页数量 * FROM [Position]
ORDER BY [ID] DESC))
当sql语句为:SELECT TOP 0 * FROM [Position] 报错,使用时可以对第一页写成:
SELECT TOP 每页数量 * FROM [Position] ORDER BY [ID] ASC 或 SELECT TOP 每页数量 * FROM [Position] ORDER BY [ID] ASC DESC
摘自——http://blog.csdn.net/huixx/article/details/5645155