select * from 表a where not exists(select 1 from 表b where date = 表a.date)
select * from 表a where not exists(select 1 from 表b where date = 表a.date) and date between '2003-1-1' and '2003-1-3'
我来降低该题的难度: 选出断码的数据:select ID ,(select min(ID) from #T where ID>a.ID) ,(select min(ID) from #T where ID > a.ID) - ID from #T a --where (select min(ID) from #T where ID > a.ID) - ID > 1 order by ID
and date between '2003-1-1' and '2003-1-3'
选出断码的数据:select ID
,(select min(ID)
from #T
where ID>a.ID)
,(select min(ID)
from #T
where ID > a.ID) - ID
from #T a
--where (select min(ID) from #T where ID > a.ID) - ID > 1
order by ID