Re: Running Total of a column on a SELECT

"Terence" <[EMAIL PROTECTED]> wrote: > > Is it possible to add the the running total of a column to the next row, > something like this: > > item,amount > - > x,100 > y,200 > z,50 > > and get a result like this: > > item,amount > - > x,100 > y,300 > z,350 Take a look at user variables.

Running Total of a column on a SELECT

Dear All, Is it possible to add the the running total of a column to the next row, something like this: item,amount - x,100 y,200 z,50 and get a result like this: item,amount - x,100 y,300 z,350 Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To