SQL 最后一行加合计功能

select cast(Address as varchar(6)) as Address,cast(CommercialType as varchar(6)) as CommercialType,EnterAmount,AccessAmount,OnlineAmount,Previousonline from #Result

union

select '合计' as  Address ,'' as CommercialType,sum(EnterAmount) as CommercialType,sum(AccessAmount) as AccessAmount,sum(OnlineAmount) as  OnlineAmount,sum(Previousonline) as     Previousonline
  from #Result where
  address=@Address or @Address=''
  and  CommercialType=@CommercialType or @CommercialType=''