17,086
社区成员
发帖
与我相关
我的任务
分享
select t1.*,
case when t1.sm < 20 then 0
when t1.sm >= 20 and lead(t1.sm) over(order by t1.id) < 20 then
t1.sm - 20
else t1.qty
end
from (
select t1.*,
sum(t1.qty) over(partition by t1.item_code order by id) sm
from tab1 t1
) t1