22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t table
(
isid int primary key identity(1,1),
amount decimal(18,2)
)
insert into @t(amount) values(23.43)
insert into @t(amount) values(213.43)
insert into @t(amount) values(523.3)
insert into @t(amount) values(23.4)
insert into @t(amount) values(263.23)
;WITH TT
AS(
SELECT a.isid,a.amount,SUM(b.amount) AS smount
FROM @t A
INNER JOIN @t B ON A.isid >=b.isid --注意这里的写法
GROUP BY a.isid,a.amount)
SELECT isid,amount FROM TT WHERE smount<500
/*
isid amount
1 23.43
2 213.43*/