---
title: "Calculate Running Total, Total of a Column and Row"  
description: "Calculate Running Total, Total of a Column and Row"  
author: "Anonymous User"  
published: 2015-11-06  
updated: 2015-11-06  
canonical: https://www.mindstick.com/forum/33577/calculate-running-total-total-of-a-column-and-row  
category: ".net"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# Calculate Running Total, Total of a Column and Row

i want to calculate [running total](https://www.mindstick.com/forum/160914/sql-query-to-calculate-running-total-in-sql-server) in [sqlserver](https://www.mindstick.com/forum/33737/between-condition-in-sqlserver) please give me any solution.

## Replies

### Reply by Anonymous User

Many times, you required to show information of each transaction and also keep a Running Total and Final Total like GridView in Asp.Net. Now I am going to explain, how can you achieve this using SQL Query in simple and easy way.

Suppose you have the below order table and has the data as shown below:

```
select CO.CustomerID, CO.CustomerName
 ,(select sum(Amount) from [order]
 where OrderID <=ord.OrderID)
 'Running Total'
from Customer CO inner join [order] as ord on CO.CustomerID=ord.CustomerID 
```

```

```


---

Original Source: https://www.mindstick.com/forum/33577/calculate-running-total-total-of-a-column-and-row

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