主页 / dba / 问题 / 233843
Accepted
M.I.M.F
Asked: 2019-04-04 06:23:19 +0800 CST

如何获取自定义查询的总和

  • 772

我在下面创建了一个关系数据库结构， 在此处输入图像描述

从这个关系表中，我想在我的查询下方获取所有数据的总和，

SELECT ((BASE_InvoiceLine.Price - IIf(SUM(BASE_Expense.Amount) IS NULL, BASE_PurchaseLine.Price, (BASE_PurchaseLine.Price + SUM(BASE_Expense.Amount)))) + BASE_PurchaseLine.Recycle) AS ProfitRecycle
FROM BASE_PurchaseLine INNER JOIN BASE_InvoiceLine ON BASE_PurchaseLine.PurchaseLineId = BASE_InvoiceLine.PurchaseLineId AND (BASE_PurchaseLine.IsDelete = 0) INNER JOIN BASE_Invoice ON BASE_InvoiceLine.InvoiceId = BASE_Invoice.InvoiceId AND (BASE_Invoice.IsDelete = 0) AND (BASE_InvoiceLine.IsDelete = 0) LEFT OUTER JOIN BASE_Expense ON BASE_PurchaseLine.PurchaseLineId = BASE_Expense.PurchaseLineId AND (BASE_Expense.IsDelete = 0)
GROUP BY BASE_PurchaseLine.Price, BASE_InvoiceLine.Price, BASE_PurchaseLine.Recycle

以上查询仅显示所有值..问题是如何获得此查询结果的总和，

谢谢

sql-server sql-server-2008-r2

1 个回答

  1. Best Answer

    最简单的方法是将查询包装在派生表或 CTE 中，然后执行 SUM ：

    SELECT sum(ProfitRecycle) AS SumProfitRecyxle
FROM
    (
    -- 
    -- your query here
    --
    ) AS dv ;
    • 3

相关问题