SELECT DATE_TRUNC('month', OrderDate) AS Month, SUM(Quantity) AS TotalQuantity FROM Orders GROUP BY Month;
或者: SELECT MONTH(OrderDate) AS Month, SUM(Quantity) AS TotalQuantity FROM Orders GROUP BY Month;
上一篇:按月份汇总和计数,以该月的最后一天显示。
下一篇:按月份汇总日期时间值