问题一:
select * from C:\test\a.dbf where SZCLNNO not in (select top 10 SZCLNNO from C:\test\a.dbf order by DLASTDATE,SZLASTTIME ) select * from C:\test\a.dbf where SZCLN
select * from C:\test\a.dbf where SZCLNNO not in (select top 10 SZCLNNO from C:\test\a.dbf order by DLASTDATE,SZLASTTIME ) select * from C:\test\a.dbf where SZCLN