forum

home / developersection / forums / how to calculate column summary in sql server.

How to Calculate Column Summary in sql server.

Anonymous User 1940 12-Jan-2016

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

sql server sql sql server 2008 sql server 2012

Updated on 12-Jan-2016

Anonymous User

Other

I am a content writter !

Message

Can you answer this question?

1 Answers

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

MindStick Training