Query for running total in SQL Server

S Douglas

Rate me:

2.00/5 (1 vote)

26 Aug 2011CPOL

9.6K

Another way of getting totals, whether it be by group or set is to use the CUBE and ROLLUP predicates.By group (each grouping of FIELD_DESCRIPTION will have a total sum):SELECT FIELD_DESCRIPTION , SUM(FIELD_VALUE)FROM tbl_DataGROUP BY FIELD_DESCRIPTIONWITH CUBEOr:By Cube...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Query for running total in SQL Server

25 Aug 2011iamalik

I guess this is more faster:SELECT T1.Field1, SUM(T2.Field1) FROM [Table] T1, [Table] T2WHERE T1.Field1 >= T2.Field1GROUP BY T1.Field1

SQL-Server

2. Query for running total in SQL Server

24 Aug 2011Elina Blank

Using window functions (partition by) will speed up the process:SELECT Val, SUM(Val) OVER (Partition BY [YourPartitionValue] Order BY [OrderColumn] as CumulativeSumFROM [Table]

SQL-Server

3. Query for running total in SQL Server

31 Aug 2011Mukit, Ataul

4 alternatives

Calculate running total or cumulative sum from a table in a SQL Server database.

SQL-Server

4. Query for running total in SQL Server

4 Sep 2011fordc03

This will work on SQL 2000/2005/2008.Most cumulative aggregations have constraints such as a begin and end date or grouped by customers.Your solution is good for a single aggregation without much filtering. People will find that the query plans generated would be very similiar to that of...

SQL-Server