From: Date: August 14 2004 12:29am
Subject: Using SUM in a special way
List-Archive: http://lists.mysql.com/mysql/170947
Message-Id: <1092436157.2101.21.camel@pc2s82.local>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7BIT

Hi,
  I would like to use SUM or any other function to sum a series of
records as in the following example.

I have this table T1

	Col1	Col2 
	1	20
	2	10
	1	10
	2	 5
	1	20
	3	10

and would like to obtain this result from a query

	Col1	Col2	Col3
	1	20	20
	1	10	30
	1	20	50
	2	10	10
	2	 5	15
	3	10	10

Column Col3 should carry forward and sum values from Col2

Is that possible ?, with SQL I mean...


Thank you 
Mauricio