Article:  |
SQL Subqueries | |
| Subject: | accumulate a field | |
| Date: | 2006-04-05 21:30:05 | |
| From: | paul21_7 | |
|
Response to: accumulate a field
|
||
|
SELECT date, qty, ( (SELECT qty FROM table b WHERE b.date = (a.date - 1)) + qty ) tqty FROM table a
|
||
Showing messages 1 through 2 of 2.
-
accumulate a field
2006-07-31 07:44:28 kaczmar [View]
it doesn't really work for me. It accumulates a record above only... Is there actually a way to accumulate values in sql without using procedures? -
accumulate a field
2007-11-15 23:14:04 AdamBerko [View]
Here is how I did it. Seems to work fine
select ObjectID,StartDate,cscfActiveUsers,
(
select sum(cscfActiveUsers)
from cscf_data b
where b.StartDate<=a.StartDate
and a.ObjectID=b.ObjectID
) as summ
from cscf_data a
order by ObjectID
