--这个意思?
select * from biao1 a
where not exists
(select * from bao1 where disk = a.disk and CreateFileDate >a.CreateFileDate)
---还是:
select * from biao1
where CreateFileDate =( select max(CreateFileDate) from biao1 )
Dsik 是盘符 CreateFileDate 是文件建立日期
检索出所有Disk上日期最早的记录,包括相同CreateFileDate的但Disk不同的所有记录
select *
from bao1 a
where not exists(select 1 from bao1 where disk = a.disk and CreateFileDate >a.CreateFileDate)