SELECT MONTH(Date) AS Month, SUM(Quantity) AS QuantitySum FROM YourTable GROUP BY MONTH(Date) ORDER BY MONTH(Date)
上一篇:按月份汇总数量的SQL查询需要怎样实现?
下一篇:按月份获取特定部门员工数量的SQL查询