17,377
社区成员
发帖
与我相关
我的任务
分享
with table1 as
(
select '00001' posno, '201310310001' flowno, 1 qty, 1 sum_lj union all
select '00001' posno, '201310310002' flowno, -1 qty, 0 sum_lj union all
select '00001' posno, '201310310003' flowno, 1 qty, 1 sum_lj union all
select '00001' posno, '201310310004' flowno, -1 qty, 1 sum_lj union all
select '00001' posno, '201310310005' flowno, 1 qty, 1 sum_lj union all
select '00001' posno, '201310310006' flowno, -1 qty, 3 sum_lj
)
select posno, flowno, qty, sum_lj
, (select sum(qty) from table1 b where b.flowno<=a.flowno) sum_new
from table1 a