select manno ,cusno, manqty,sum(manqty)
OVER(PARTITION BY cusno
ORDER BY cfmdate
ROWS unbounded preceding -- unbounded preceding只能在2012及以上版本中才能执行
) AS sumnum
from f1.dbo.manmas where cfmdate>'2020-04-15'
sql server 逐行求和-一当前行是前边行累加
最新推荐文章于 2023-03-15 20:14:03 发布