27,579
社区成员
发帖
与我相关
我的任务
分享
select left(convert(varchar(6),dateadd(m,-1,日期),112),4)+convert(varchar(1),(convert(int,right(convert(varchar(6),dateadd(m,-1,日期),112),2))-1)/3+1) as 季度,sum(销售额) as 销售额
from tb group by left(convert(varchar(6),dateadd(m,-1,日期),112),4)+convert(varchar(1),(convert(int,right(convert(varchar(6),dateadd(m,-1,日期),112),2))-1)/3+1)
select y,q, sum(销售额) as 销售额
from (
select *, year(日期) as y,
case when month(日期) in (2,3,4) then q1,
when month(日期) in (5,6,7) then q2,
when month(日期) in (8,9,10) then q3,
when month(日期) in (11,12,1) then q4
end as q
from tb
) t
group by y,q
select year(日期) 年, datepart(quarter , 日期) 季度 , sum(销售额) 销售额
from tb
group by year(日期) , datepart(quarter , 日期)
selet sum(xiaoshoue)
from tb
where month(riqi) in (2,3,4)
union all
selet sum(xiaoshoue)
from tb
where month(riqi) in (5,6,7)
quarter