delete from tb
where id in(select t.id
from(
select a.id, sum(b.id) as total
from tb a
join tb b
on b.id <= a.id
group by a.id
) t
where total= 20
)
/*
id total
----------- -----------
1 1
2 3
3 6
4 10
5 15
6 21
7 28
8 36
9 45
10 55
11 66
12 78
--里面没有累加等于20的数据
*/
select number into #t from master..spt_values where type='p' and number between 1 and 256
select a.number beginnum,b.number endnum,
(select sum(number) from #t where number between a.number and b.number) sumrange
from #t a,#t b where b.number>a.number
and (select sum(number) from #t where number between a.number and b.number)=20
order by 1
/*beginnum endnum sumrange
----------- ----------- -----------
2 6 20
（所影响的行数为 1 行）
