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

Recommended for You
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >