Re: Compute in Oracle

--
-- Used all the available functions
--
mag_at_mutation_mutation > get q
  1  clear breaks
  2  clear computes
  3  set feed on
  4  set term on
  5  break on job
  6  compute sum LABEL 'Total' -
  7     avg LABEL 'Average'-
  8     min LabEL 'Minimum'-
  9     Max LABEL 'Maximum'-
 10     of sal inc_sal comm on job
 11* select job,ename,sal,(sal+100) inc_sal, nvl(comm,0) comm  from emp
order by job ;
 12  .
mag_at_mutation_mutation > @q

JOB       ENAME             SAL    INC_SAL       COMM
--------- ---------- ---------- ---------- ----------
ANALYST   SCOTT            3000       3100          0
          FORD             3000       3100          0


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

Average                    3000       3100          0
Minimum                    3000       3100          0
Maximum                    3000       3100          0
Total                      6000       6200          0
CLERK     SMITH             800        900          0
          ADAMS            1100       1200          0
          MILLER           1300       1400          0
          JAMES             950       1050          0


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

Average                  1037.5     1137.5          0
Minimum                     800        900          0
Maximum                    1300       1400          0
Total                      4150       4550          0
MANAGER   JONES            2975       3075          0
          CLARK            2450       2550          0
          BLAKE            2850       2950          0


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

Average              2758.33333 2858.33333          0
Minimum                    2450       2550          0
Maximum                    2975       3075          0
Total                      8275       8575          0
PRESIDENT KING             5000       5100          0


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

Average                    5000       5100          0
Minimum                    5000       5100          0
Maximum                    5000       5100          0
Total                      5000       5100          0
SALESMAN  ALLEN            1600       1700        300
          MARTIN           1250       1350       1400
          TURNER           1500       1600          0
          WARD             1250       1350        500


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

Average                    1400       1500        550
Minimum                    1250       1350          0
Maximum                    1600       1700       1400
Total                      5600       6000       2200