Calculate Running Total in SQL

In this article we will show you, How to write a SQL Query to Calculate Running Total in SQL Server with example. This is one of the common SQL Interview Question that you might face in the interviews. For this example, We are going to use the below shown data

Above screenshot will show you the data inside the NewCustomer table present in the SQL Tutorial database.

Calculate SQL Running Total Example 1

In this example we will show you, How to Calculate SQL Server Running Total using the SUBQUERY.

T-SQL CODE

OUTPUT

Calculate Running Total in SQL Server Example 2

In this example we will show you, How to calculate SQL Server Running Total using the JOIN, GROUP BY, and ORDER BY Clause.

T-SQL CODE

OUTPUT

Calculate Running Total in SQL Server Example 3

In this example we will show you, How to calculate SQL Server Running Total using the SUM Function, and OVER.

T-SQL CODE

and the more traditional way is

T-SQL CODE

OUTPUT

Thank You for Visiting Our Blog