RE: SQL Help, Please!

From: Jane Gao <JGao_at_kalgold.com.au>
Date: Fri, 26 May 2000 14:26:59 +0800
Message-Id: <10508.106824@fatcity.com>

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_01BFC6DB.6A3C965A
Content-Type: text/plain

Hi, Dear gurus, I 'd like to say a sincere thanks to everyone that answered. It is very much appreciated!!
Cheers
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_at_kalgold.com.au

>
>
> -----Original Message-----
> From: Serge Kosourikhin [SMTP:kosour_at_braz.ru]
> Sent: Fri, 26 May 2000 15:05
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SQL Help, Please!
>
> Try this
> SQL > select a.DateOP, sum(b.Tons) as ACC_Tons from t1 a, t1 b
> where b.DateOP <= a.DateOP
> group by a.DateOP;
>
> Serge Kosourikhin
> Oracle DBA
> JSC Bratsk Aluminium Plant
>

------_=_NextPart_001_01BFC6DB.6A3C965A
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">

<TITLE>RE: SQL Help, Please!</TITLE>
</HEAD>
<BODY>

Hi, Dear gurus, I 'd = like to say a sincere thanks to everyone that answered. It is very much = appreciated!!

<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Cheers</FONT>
<BR><B><FONT SIZE=3D2 FACE=3D"Tahoma">Jane Gao</FONT></B>
<BR><B><FONT SIZE=3D2 FACE=3D"Tahoma">Senior Application Support =

Analyst
 Kalgoorlie Consolidated Gold = Mines
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=
------------------</FONT></B>

( Phone :  (08) 9022 1129 .Fax    =         :  (08) 9022 = 1149
 +Address        = :  PMB 27
         =             KALGOORLIE  WA  = 6430
 *E-mail :  jgao_at_kalgold.com.au

</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Serge Kosourikhin [SMTP:kosour_at_braz.ru] Sent:   Fri, 26 May 2000 15:05 To:     Multiple recipients of list ORACLE-L Subject:       = Re: SQL Help, Please!

Try this SQL > select a.DateOP, sum(b.Tons) = as ACC_Tons  from t1 a, t1 b   where b.DateOP <=3D = a.DateOP
   group by a.DateOP;

<P><FONT SIZE=3D2 FACE=3D"Arial">Serge Kosourikhin</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Oracle DBA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">JSC Bratsk Aluminium Plant</FONT>

Received on Fri May 26 2000 - 01:26:59 CDT