聚合 应该如何处理

Question

select * from A
union 
select 0,'','','','',sum(ee),sum(ff),sum(gg) from A

Answer 1

select * from tb
union
select null,null,null,null,null,sum(ee),sum(ff),sum(gg)
from tb

Answer 2

select [id]=convert(varchar,id),
       aa,bb,cc,dd,ee,ff,gg
from A
union all
select '','','','','',sum(ee),sum(ff),sum(gg) from A

Answer 3

这样显示也是可以的 select id,aa,bb,cc,dd,ee,ff,gg from a compute max(ee),max(ff),max(gg)

Answer 4

不好意思，发错了select id,aa,bb,cc,dd,ee,ff,gg from a compute SUM(ee),SUM(ff),SUM(ff)