用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)
楼上兄弟漏了条件啊
use Northwind
select sum(Freight) from orders where orderdate between '1996/07/12' and '1996/11/16' group by year(orderdate),month(orderdate)