试试
With cte As
(
Select 进出单号 ,
进出日期 ,
进出类别 ,
入库数量 ,
出库数量 ,
进出数量 ,
计量单位 ,
ROW_NUMBER() OVER ( PARTITION BY 产品编码 ORDER BY 进出日期, 盘点序号 ) As rowNum
FROM uv_ck110
WHERE 进出日期 >= '2019-06-30'
And 产品编码 = 'B0101010'
)
Select t2.*,
( Select SUM(进出数量)
FROM cte t1
WHERE t1.rowNum<=t2.rowNum
) As 累计数量
FROM cte t2