ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
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
...



1 to 1 of 1
1 to 1 of 1