select top 10 * from l_zzzyjsryylb
where recno >=100 and recno < 200
order by recno
--- OR (order by desc)select top 10 * from l_zzzyjsryylb
where recno >=100 and recno < 200
order by recno desc
where recno >=100 and recno < 200
order by recno
--- OR (order by desc)select top 10 * from l_zzzyjsryylb
where recno >=100 and recno < 200
order by recno desc
select top 200 * from table order by id asc)
order by id desc
你的寫法是對的啊!
这里的recno不是字段,
因为在foxpro中,我记得可以通过recno控制取得的数据。用文字描述一下就类似于:如何取得在表中记录号大于50小于100的记录。用top只能取得最顶端的,我要的是中间的。