SELECT MONTH(OrderDate) AS Month, SUM(Quantity) AS TotalQuantity FROM TableName GROUP BY MONTH(OrderDate)
上一篇:按月份求Quantity的总和所需的SQL语句。
下一篇:按月份日期进行过滤