我想知道如何根据另一列的值相加,如下所示。我尝试了以下两种方法,每种方法都会由于聚合函数而产生错误。我正在尝试通过下面的查询获取NonDistinctTotals。SELECT SUM(InvoiceSaleAmt) AS NonDistinctTotals, SUM(case when count(*) over (partition by InvoiceNo)ELSE 0 END) AS CashTotalgroup by LocationId, InvoiceNo
错误:窗
对于不完整的数据集,我需要执行聚合函数,同时避免所有来自同一个表的特定聚合函数为空。因此,例如,我尝试将其放入子查询中: WITH spend AS ( (SUM(current_spend)-SUM(baseline_spend))/SUM(baseline_spend(current_sales)-SUM(baseline_sales))/SUM(baseline_s