不用临时表:select char_datetime,fh_number ,all_money
from (
select convert(varchar(10), fh_datetime,120) as char_datetime,fh_datetime,
fh_number ,all_money,1 as type
from fh_table
union all
select cast(datepart(quarter,fh_datetime) as varchar)+'季度合计' as char_datetime,
max(fh_datetime) as fh_datetime,
sum(fh_number) fh_number,sum(all_money) all_money,2 as type
from fh_table
group by cast(datepart(quarter,fh_datetime) as varchar)+'季度合计'
) as x
order by fh_datetime,type
from (
select convert(varchar(10), fh_datetime,120) as char_datetime,fh_datetime,
fh_number ,all_money,1 as type
from fh_table
union all
select cast(datepart(quarter,fh_datetime) as varchar)+'季度合计' as char_datetime,
max(fh_datetime) as fh_datetime,
sum(fh_number) fh_number,sum(all_money) all_money,2 as type
from fh_table
group by cast(datepart(quarter,fh_datetime) as varchar)+'季度合计'
) as x
order by fh_datetime,type
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货