Message-Id: <10508.106800@fatcity.com> From: Jane Gao Date: Fri, 26 May 2000 07:50:45 +0800 Subject: SQL Help, Please! This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFC6A4.0C163482 Content-Type: text/plain Hi, Gurus, Could anyone help me with this problem(we are running on Oracle 7.3.4): I have a table with the following fields and data: DateOP Tons ------------ ------------- 01/05/2000 4.5 02/05/2000 3.5 03/05/2000 2 04/05/2000 4 I want to write a single SQL to achieve accumulated 'Tons' results like this: DateOP ACC_Tons ------------ ------------- 01/05/2000 4.5 02/05/2000 8 03/05/2000 10 04/05/2000 14 Thanks in advance. Jane Gao Senior Application Support Analyst Kalgoorlie Consolidated Gold Mines --------------------------------------------------------------------------- > * Phone : (08) 9022 1129 *Fax : (08) 9022 1149 > *Address : PMB 27 KALGOORLIE WA 6430 > *E-mail : jgao@kalgold.com.au > > ------_=_NextPart_001_01BFC6A4.0C163482 Content-Type: text/html Content-Transfer-Encoding: quoted-printable SQL Help, Please!

Hi, Gurus, Could anyone help me with = this problem(we are running on Oracle 7.3.4):

I have a table with the following = fields and data:

DateOP  =         Tons
------------    = -------------
01/05/2000      4.5
02/05/2000      3.5
03/05/2000      2
04/05/2000      4

I want to write a single SQL to = achieve accumulated 'Tons' results like this:

DateOP  =         ACC_Tons
------------    = -------------
01/05/2000      4.5
02/05/2000      8
03/05/2000      10
04/05/2000      14

Thanks in advance.
Jane Gao
Senior Application Support = Analyst
Kalgoorlie Consolidated Gold = Mines
---------------------------------------------------------= ------------------
( Phone :  (08) 9022 1129
.Fax    =         :  (08) 9022 = 1149
+Address        = :  PMB 27
        =             KALGOORLIE  WA  = 6430
*E-mail :  jgao@kalgold.com.au