在access 中,实现真分页可以用以下方法:
SQL代码:
SELECT TOP 10 id, photoID, ClassID, ClassName, Title, rownumber
FROM (SELECT a.id, a.photoID, a.ClassID, a.ClassName, a.Title, COUNT(*) AS rownumber
FROM (Photo a INNER JOIN
Photo b ON a.photoID < b.photoID)
GROUP BY a.id, a.photoID, a.ClassID, a.ClassName, a.Title) a_1
WHERE (rownumber< 11)
ORDER BY rownumber desc
这条语句的意思是“查询行号为1到10的记录”。
举个例子:记录按ID倒序排列,每页10条记录,要查询第10页的记录代码如下:
SELECT TOP 10 id, photoID, ClassID, ClassName, Title, rownumber
FROM (SELECT a.id, a.photoID, a.ClassID, a.ClassName, a.Title, COUNT(*) AS rownumber
FROM (Photo a INNER JOIN
Photo b ON a.photoID < b.photoID)
GROUP BY a.id, a.photoID, a.ClassID, a.ClassName, a.Title) a_1
WHERE (rownumber< 111)
ORDER BY rownumber desc
以此类推
有不明的可以留言。欢迎交流~