Home -> Usenet -> c.d.o.tools -> Re: Compute in Oracle

Re: Compute in Oracle

From: Mahesh Rajendran <Magvivek_at_gmail.com>
Date: 23 Feb 2005 07:43:53 -0800
Message-ID: <1109173433.460577.124890_at_g14g2000cwa.googlegroups.com> 





[Quoted] mag_at_mutation_mutation > break on job
mag_at_mutation_mutation > compute sum of sal on job
mag_at_mutation_mutation > compute avg of sal on job
mag_at_mutation_mutation > /

JOB       ENAME             SAL
--------- ---------- ----------
ANALYST   SCOTT            3000
          FORD             3000


*********            ----------

avg                        3000
CLERK     SMITH             800
          ADAMS            1100
          MILLER           1300
          JAMES             950


*********            ----------

avg                      1037.5
MANAGER   JONES            2975
          CLARK            2450
          BLAKE            2850


*********            ----------

avg                  2758.33333
PRESIDENT KING             5000


*********            ----------

avg                        5000
SALESMAN  ALLEN            1600
          MARTIN           1250
          TURNER           1500
          WARD             1250


*********            ----------

avg                        1400





14 rows selected.
Received on Wed Feb 23 2005 - 16:43:53 CET












Original text of this message