Women in Technology

Hear us Roar



Article:
  SQL Subqueries
Subject:   accumulate a field
Date:   2006-03-02 01:53:41
From:   st.chen
thanks in advance,


if i have a table having the following 2 fields:
date qty
-------- ---
20060101 100
20060102 120
20060103 111
...


can we get the following data using a SELECT statement?
date qty tqty
-------- --- ----
20060101 100 100
20060102 120 220
20060103 111 331
...


Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • accumulate a field
    2006-04-05 21:30:05  paul21_7 [View]

    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