27,579
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([date] Date,[elec] int)
Insert #T
select '2016-1-1',0 union all
select '2016-1-2',20 union all
select '2016-1-3',200 union all
select '2016-1-8',0 union all
select '2016-1-9',10 union all
select '2016-1-11',0 union all
select '2016-1-12',8 --如果是8不计算
Go
--测试数据结束
SELECT COUNT(1) AS 次数
FROM #T a
JOIN #T b ON DATEDIFF(DAY, a.date, b.date) = 1
WHERE a.elec = 0
AND b.elec >= 10