forum

Home / DeveloperSection / Forums / How to Calculate Column Summary in sql server.

Ask Question
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

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

answer 415871201102802

 

Liked By