Re: Compute in Oracle
From: Mahesh Rajendran <Magvivek_at_gmail.com>
Date: 23 Feb 2005 08:49:42 -0800
Message-ID: <1109177382.529128.46490_at_z14g2000cwz.googlegroups.com>
Date: 23 Feb 2005 08:49:42 -0800
Message-ID: <1109177382.529128.46490_at_z14g2000cwz.googlegroups.com>
Unfortunately , your example IS NOT READABLE. I dont get a thing out of it.
mag_at_mutation_mutation > compute avg of comm on job
mag_at_mutation_mutation > compute sum of sal inc_sal on job
mag_at_mutation_mutation > break on job
mag_at_mutation_mutation > /
JOB ENAME SAL INC_SAL COMM
--------- ---------- ---------- ---------- ----------
ANALYST SCOTT 3000 3100 0
FORD 3000 3100 0
********* ---------- ---------- ----------
avg 0
sum 6000 6200
CLERK SMITH 800 900 0
ADAMS 1100 1200 0
MILLER 1300 1400 0
JAMES 950 1050 0
********* ---------- ---------- ----------
avg 0
sum 4150 4550
MANAGER JONES 2975 3075 0
CLARK 2450 2550 0
BLAKE 2850 2950 0
********* ---------- ---------- ----------
avg 0
sum 8275 8575
PRESIDENT KING 5000 5100 0
********* ---------- ---------- ----------
avg 0
sum 5000 5100
SALESMAN ALLEN 1600 1700 300
MARTIN 1250 1350 1400
TURNER 1500 1600 0
WARD 1250 1350 500
********* ---------- ---------- ----------
avg 550
sum 5600 6000
14 rows selected. Received on Wed Feb 23 2005 - 17:49:42 CET