SQL server 累加求和
1.
SELECT SalesOrderID, ProductID, OrderQty ? ? ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS Total ? ? ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS "Avg" ? ? ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS "Count" ? ? ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS "Min" ? ? ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS "Max" FROM Sales.SalesOrderDetail? WHERE SalesOrderID IN(43659,43664);
2.
select SchSno,convert(varchar(10),a.Dates,120) Dates, sum(Amt_avail) over(partition by SchSno order by convert(varchar(10),a.Dates,120)) as PeriodPreAmt from jr_creditUserAcct a
到此这篇关于sql server 累计求和实现代码的文章就介绍到这了,更多相关sql server 累计求和内容请搜索
更多SQL内容来自木庄网络博客