应修改如下：
select 年, sum([第一季度]) as [第一季度合计], sum([第二季度]) as [第二季度合计],sum([第三季度]) as [第三季度合计], sum([第四季度]) as [第四季度合计], sum( 全年) as 全年合计
From
(SELECT year(u_time) as 年,iif(datepart('q',u_time)=1,1,0) as [第一季度], iif(datepart('q',u_time)=2,1,0) as [第二季度],iif(datepart('q',u_time)=3,1,0) as [第三季度], iif(datepart('q',u_time)=4,1,0) as [第四季度], 1 as 全年 from cust_infor)
group by 年;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024