我如何将Colums的总和加到一个Colum中 [英] How I Do Sum The Sum Of Colums In To One Colum

问题描述

亲爱的所有人，



我想找到解决SQL的解决方案

Dear All,

I want solution for fallowing SQL

SELECT [INWARD RG].MD
	,[INWARD RG].UNIT
	,[INWARD RG].STOCK
	,[INWARD RG].[SumOfConverted Qty]
	,[INWARD RG].SumOfPurchase1
	,[INWARD RG].[SumOfSite Return Qty]
FROM [INWARD RG];

INWARD RG查询中的
我希望STOCk作为[SumOfConverted Qty] + SumOfPurchase1 + [SumOfSite返回数量]的总和



请从上面告诉SQL中的解决方案

请帮帮我...

in INWARD RG Query i want STOCk as a Sum of [SumOfConverted Qty]+SumOfPurchase1+[SumOfSite Return Qty]

Please tell the solution in SQL from as above
Please help me...

推荐答案

这是什么类型的数据库？语法对我来说很奇怪。如果我这样做，我会做这样的事情：

What kind of database is this? The syntax looks strange to me. If I were doing this I would simply do something like this:

SELECT SUM(column1) as Total1, SUM(column2) as Total2, SUM(column3) as Total3, 
SUM(column1 + column 2 + column3) as GrandTotal

FROM MyTable

它应该简单如下

It should be simple as below

SELECT [INWARD RG].MD
    ,[INWARD RG].UNIT
    ,[SumOfConverted Qty]+SumOfPurchase1+[SumOfSite Return Qty] As STOCK
    ,[INWARD RG].[SumOfConverted Qty]
    ,[INWARD RG].SumOfPurchase1
    ,[INWARD RG].[SumOfSite Return Qty]
FROM [INWARD RG];

这篇关于我如何将Colums的总和加到一个Colum中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！