---
title: "How to  Calculate  Column Summary in sql server."  
description: "How to  Calculate  Column Summary in sql server."  
author: "Anonymous User"  
published: 2016-01-12  
updated: 2016-01-12  
canonical: https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server  
category: "c#"  
tags: ["sql server", "sql", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# How to  Calculate  Column Summary in sql server.

I want to Use Calculate [Column](https://www.mindstick.com/forum/12694/drop-down-list-in-asp-dot-net-for-c-sharp-column-colour-does-not-belong-to-table) [Summary](https://answers.mindstick.com/qa/31049/write-a-summary-about-odyssey-by-homer) in [sql server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server). How to do this please help me.

## Replies

### Reply by Anonymous User

```
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', 2400select Name, SUM(amount) as amount from @tablegroup by name union all select 'Total',SUM(amount) from @table
```

![How to  Calculate  Column Summary in sql server.](https://www.mindstick.com/mindstickforums/81aded82-b11d-48c7-891b-a900f3cbec51/images/91d361df-6408-4e69-966d-dcb40d4dff75.png)


---

Original Source: https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.