SQL日期范围和总计 [英] SQL Date Range and Totaling

问题描述

嘿，我有一个问题，我正在尝试进行选择，如下所示:

Hey I have a problem I''m trying to do a select as seen below:

SELECT SUM(Invoice.TotalPrice) AS "Total", Customer.LastName, Customer.FirstName
FROM Invoice
INNER JOIN Customer
ON Invoice.CustomerID = Customer.CustomerID
WHERE DATEDIFF ( MONTH , Invoice.DateOrderPlaced , GETDATE() ) > 3 AND "Total"  > 20000
GROUP BY Invoice.CustomerID, Customer.LastName, Customer.FirstName;

我遇到的问题是:

The problem i''ve got is the:

3 AND "Total"  > 20000

我希望它表示客户ID相同时的总价.任何人有任何建议吗?

I want it to mean the total of price where customer ID is the same. Anyone got any suggestions?

推荐答案

只需在HAVING子句中使用summary函数

Just use the summary function in a HAVING clause

SELECT SUM(Invoice.TotalPrice) AS "Total", Customer.LastName, Customer.FirstName
FROM Invoice
INNER JOIN Customer
ON Invoice.CustomerID = Customer.CustomerID
WHERE DATEDIFF ( MONTH , Invoice.DateOrderPlaced , GETDATE() ) > 3
GROUP BY Invoice.CustomerID, Customer.LastName, Customer.FirstName
HAVING SUM(Invoice.TotalPrice) > 20000

这篇关于SQL日期范围和总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！