How to Calculate Column Summary in sql server.

Anonymous User 2029 12 Jan 2016

I want to Use Calculate Column Summary in sql server. How to do this please help me.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 12 Jan 2016

declare @table table(Name varchar(100), Amount decimal(12,2)) 
insert into @table 
select 'arjun', 3000 union all 
select 'pawan', 2000 union all 
select 'rahul', 3000 union all 
select 'rahul', 2500 union all 
select 'pawan', 2300 union all 
select 'arjun', 2400
select Name, SUM(amount) as amount from @table
group by name 
union all 
select 'Total',SUM(amount) from @table

forum

How to Calculate Column Summary in sql server.

Can you answer this question?

1 Answers