<数据库问题>如何查询第n到第m条记录？

[xuqiang007]

如何查询第n到第m条记录？(n<m,意思为按数据的物理顺序查询从第n到m条记录)。

[intersun]

笨方法，先用move方法指向第n行，再用do while语句循环遍历要查找的字段，直到第m行。

[xuqiang007]

我想知道有没有可以执行的SQL语句来实现？

[yxbi]

用
for i=0 to m
if i>=n then
xxxxxx' 读出数据来
end if
rs.movenext
next i

[karma]

1. if the records are ordered by some fields and you know how to calcuate the n-m records from those fields, for example, you have an identity field, you can do
select * from where id >=n and id <=m

then that will be the easiest way

2. assume m >n, in SQL Server, you can get the top m records, reverse the order, get the top m-n+1 records

3. use the above mentioned method