select sum(num) from tableA group by year(date1) ,month(date1) 'date1为日期型字段 你试试看
楼上兄弟漏了条件啊 use Northwind select sum(Freight) from orders where orderdate between '1996/07/12' and '1996/11/16' group by year(orderdate),month(orderdate)
用datepart函数,你试试是不是你要的结果 use Northwind select sum(Freight) from orders where orderdate between '1996/07/1' and '1996/11/16' group by year(orderdate),datepart(q,orderdate)
group by year(date1) ,month(date1) 'date1为日期型字段 你试试看
use Northwind
select sum(Freight) from orders where orderdate between '1996/07/12' and '1996/11/16' group by year(orderdate),month(orderdate)
use Northwind
select sum(Freight) from orders where orderdate between '1996/07/1' and '1996/11/16' group by year(orderdate),datepart(q,orderdate)
那应该怎么办呢?