select name from
testB a where
exists
(
select * from testB b
where b.InsertTime = DATEADD(D,1,a.InsertTime) and a.name=b.name
)
and
exists
(
select * from testB b
where b.InsertTime = DATEADD(D,2,a.InsertTime) and a.name=b.name
)
group by name
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。