用 SET INDEX TO 对a.dbf 的 DLASTDATE,SZLASTTIME 建立索引 use c:\test\a.dbf set filter to SZCOCODE='01' and dtoc(DLASTDATE,1)+SZLASTTIME>'2001091017:37:06' select top 10 (SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE) from a order by 索引名 go bottom m.x=SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE set filter to SZCOCODE='01' and dtoc(DLASTDATE,1)+SZLASTTIME>'2001091017:37:06' and (SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE)>m.x select top 10 (SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE) from a order by 索引名
use c:\test\a.dbf
set filter to SZCOCODE='01' and dtoc(DLASTDATE,1)+SZLASTTIME>'2001091017:37:06'
select top 10 (SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE) from a order by 索引名
go bottom
m.x=SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE
set filter to SZCOCODE='01' and dtoc(DLASTDATE,1)+SZLASTTIME>'2001091017:37:06' and (SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE)>m.x
select top 10 (SZCLNNO+SZCOCODE+CACTYPE+SZSUBCODE) from a order by 索引名