How to Calculate Column Summary in sql server.

Anonymous User 2173 12 Jan 2016

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

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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How to Calculate Column Summary in sql server.

Can you answer this question?

1 Answers