zhangjinrui(提问者)select * ,sum(tb.数量)over(partition by tb.存货编码 )as 累积出库数量,Row_Number() over (partition by \'\' order by tb.销售出库单号) as RN
from (select rs.ccode as 销售出库单号 ,rs3.cInvCode as 存货编码,rs3.iQuantity as 数量,rs3.iorderseq as 行号
from rdrecord32 rs
left join rdrecords32 rs3
on rs.id=rs3.ID
where rs.ccode=\'2101000056\')tb