展开全部
和按32313133353236313431303231363533e78988e69d8331333365663566月份组的原理是一样的吧!
按季度分组和按月分组的区别应该就是时间段的区别吧!select case when month(date) =1 or month(date) =2
or month(date)=3 then '一季度'
when month(date) =4 or month(date) =5
or month(date)=6 then '2季度'
when month(date) =7 or month(date) =8
or month(date)=9 then '3季度'
when month(date) =10 or month(date) =11
or month(date)=12 then '4季度'
else '' end ,sum(数量)
from table
group by
case when month(date) =1 or month(date) =2
or month(date)=3 then '一季度'
when month(date) =4 or month(date) =5
or month(date)=6 then '2季度'
when month(date) =7 or month(date) =8
or month(date)=9 then '3季度'
when month(date) =10 or month(date) =11
or month(date)=12 then '4季度'
else '' end