select * from 表 a where 日期字段>='具体时1' and 日期字段<='具体时间2' and not exists (select * from 表 where 日期字段<'具体时1' and 关键数据=a.关键数据)
declare @time datetime select * from Table1 where DATEDIFF(millisecond,ti.time,@time)>0 and id not in (select id from table1 where time between time1 and time2)
select * from Table1
where DATEDIFF(millisecond,ti.time,@time)>0
and id not in (select id from table1 where time between time1 and time2)