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


Syntactically its fine ... I made a small assumption on date being the incremental field, so just alter to suit


enjoy

Full Threads Newest First

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