Thanks. This was helpful
Srini
-Original Message-
Sent: Friday, February 02, 2001 7:01 AM
To: Multiple recipients of list ORACLE-L
Hi,
ROLLUP is similar to break/compute of sql*plus. However it hasn't the same
funcionality.
With CUBE you receive the information of ROLLUP and the tot
Hi,
ROLLUP is similar to break/compute of sql*plus. However it hasn't the same
funcionality.
With CUBE you receive the information of ROLLUP and the totals or grouping
expresions of each field you include:
SQL> r
1 select deptno,job,sum(sal)
2 from emp
3* group by cube(deptno,job)
thanks
-Original Message-
Sent: Thursday, February 01, 2001 1:37 PM
To: Multiple recipients of list ORACLE-L
Just try :
SELECT deptno, job, SUM(sal)
FROM emp
group by cube(deptno, job)
/
and see the d
Just try :
SELECT deptno, job, SUM(sal)
FROM emp
group by cube(deptno, job)
/
and see the difference between rollup and cube! Cube basically adds one more
dimension, it gives summary for each value in "job" fiel
