且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在SQL中计算运行总计

更新时间:2022-12-09 19:53:02

您可以在OVER子句中将SUMORDER BY子句一起使用:

You can use SUM with ORDER BY clause inside the OVER clause:

SELECT Account, Month, Salary, 
       SUM(Salary) OVER (PARTITION BY Account ORDER BY Month) AS RunningTotal
FROM mytable