Entry

How to calculate the running total of a table

Feb 20th, 2008 23:09
dman, Matt Chatterley, Tony Bland, http://sturly.com

Assuming you have a column (e.g. 'Value') in a table and you want to
know the total of all the rows added together (Value+Value...), you
could do:
SELECT SUM(Value) AS Total FROM Table1;