How to get cumulative sum

by 
select t1.id, t1.SomeNumt, SUM(t2.SomeNumt) as sum
from @t t1
inner join @t t2 on t1.id >= t2.id
group by t1.id, t1.SomeNumt
order by t1.id

SQL Fiddle example

Output

| ID | SOMENUMT | SUM |
-----------------------
|  1 |       10 |  10 |
|  2 |       12 |  22 |
|  3 |        3 |  25 |
|  4 |       15 |  40 |
|  5 |       23 |  63 |

Edit: this is a generalized solution that will work across most db platforms. When there is a better solution available for your specific platform (e.g., gareth’s), use it!

More Related Contents:

  1. Using merge..output to get mapping between source.id and target.id
  2. SQL Server, How to set auto increment after creating a table without data loss?
  3. How can I truncate a datetime in SQL Server?
  4. Which are more performant, CTE or temporary tables?
  5. Using RegEx in SQL Server
  6. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  7. Import Excel spreadsheet columns into SQL Server database
  8. SqlServer: Login failed for user
  9. SQL Server 2008 Empty String vs. Space
  10. How to set a default value for an existing column
  11. How to drop column with constraint?
  12. SQL Server: combining multiple rows into one row
  13. SQL Server Query: Fast with Literal but Slow with Variable
  14. How do I find a stored procedure containing ?
  15. An attempt to login using SQL authentication failed
  16. SQL Server, the misleading XLOCK & optimizations
  17. How to find SQL Server running port?
  18. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  19. Changing SQL Server collation to case insensitive from case sensitive?
  20. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  21. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  22. Database design: Calculating the Account Balance
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. INFORMATION_SCHEMA vs sysobjects
  25. Merge multiple rows into a single row
  26. In SQL Server, how can I find everywhere a column is referenced?
  27. ‘Incorrect SET Options’ Error When Building Database Project
  28. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  29. Why insert-select to variable table from XML variable so slow?
  30. Generate MD5 hash string with T-SQL

Leave a Comment