594
社区成员
发帖
与我相关
我的任务
分享
if OBJECT_ID('tempdb..#t') >0 drop table #t
create table #t
(yue nvarchar(10) , qty int)
insert into #t values
(N'1月', 100),
(N'2月', 110),
(N'3月', 100),
(N'4月', 90),
(N'5月', 90),
(N'6月', 90),
(N'7月', 90);
with cte as
(
select number,NTILE(4)over(order by number) id from master..spt_values a
where type = 'P' and number between 1 and 12
)
select yue + N' 季度总和',SUM(qty)over(partition by id) 总和数量 from cte a
join #t b on substring(b.yue,1,1) = a.number
order by id