MS访问限制 [英] MS Access Limit

问题描述

在ms访问中mysql Limit的等效项是什么. TOP是不够的，因为我将使用它进行分页.

What's the equivalent of mysql Limit in ms access. TOP is not sufficient since I'm going to use it for pagination.

谢谢

推荐答案

由于这些行似乎没有任何类型的序列唯一键号，因此您需要创建一个排名列:如何在查询中对记录进行排名

Since it doesn't appear that you have any type of sequencial unique key number for these rows, you'll need to create a ranking column: How to Rank Records Within a Query

您需要确定一次返回多少行N =(10，25,100).

You need to determine how many rows at a time you will return N = (10, 25,100).

您需要跟踪用户所在的页面"以及第一和最后一个等级的值.

You need to keep track of what "page" the user is on and the values of the first and last rank.

然后，当您呼叫下一页时，它就是接下来的N行>或<.第一和最后的排名(取决于用户是转到上一页还是下一页.).

Then when you make the call for the next page it is either the next N rows that are > or < the first and last ranks (depending if the users is going to the previous or next page.).

我确定有一种计算最后一页，第一页等的方法.

I'm sure there is a way to calculate the last page, first page, etc.

这篇关于MS访问限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！