Re: Accumulated Sum

[Jay Pipes]

My guess is that for this scenario, you'll get poorer performance with UDFs (either MySQL or Postgres) compared to the >= predicate. Though, I'd love to see some benchmarks... I just don't have the time right now...perhaps an article soon...

Anyway, for your question. Try this:

SELECT s1.Date, s1.Code, s1.StockCode, s1.IN, SUM(s2.IN) as 'RunSum'
FROM Stocks s1
INNER JOIN Stocks s2
ON s1.StockCode = s2.StockCode
AND s1.Code >= s2.Code;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com