查询总数应该随着成本列的每一行继续添加 [英] Query for total should keep on adding with each row of cost Column
本文介绍了查询总数应该随着成本列的每一行继续添加的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的表格列为
Operation Cost
Material Issue 10
Material Return 20
X 30
Y 40
Z 50
我想要一个列在哪里的查询
I want want a query where columns are
Operation Cost Total
Material Issue 10 10
Material Return 20 30
X 30 60
Y 40 100
Z 50 150
即..,总和应该随着成本列的每一行不断增加
ie.., the the total should keep on adding with each row of cost Column
推荐答案
试试这个
DECLARE @Table TABLE(
ID INT IDENTITY(1,1),
Descr VARCHAR(20),
Val FLOAT
)
INSERT INTO @Table (Descr,Val) SELECT 'X', 10
INSERT INTO @Table (Descr,Val) SELECT 'Y', 20
INSERT INTO @Table (Descr,Val) SELECT 'Z', 50
INSERT INTO @Table (Descr,Val) SELECT 'A', 75
INSERT INTO @Table (Descr,Val) SELECT 'B', 100
SELECT t1.Descr,
t1.Val,
SUM(ISNULL(t2.Val,0))
FROM @Table t1 LEFT JOIN
@Table t2 ON t1.ID >= t2.ID
GROUP BY t1.Descr,
t1.Val
这篇关于查询总数应该随着成本列的每一行继续添加的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文