sql-server - 每月总销售额

Question

如果您有一个包含 SALES {Customer_ID, Price, SmallDateTime 日期} 的表。您如何报告每月的所有销售额？

SELECT Sum(Price) As Total Sales FROM SALES Group By What Having What 

Answer 1

  SELECT YEAR(date) as SalesYear,
         MONTH(date) as SalesMonth,
         SUM(Price) AS TotalSales
    FROM Sales
GROUP BY YEAR(date), MONTH(date)
ORDER BY YEAR(date), MONTH(date)