27. CUBE

CUBE() ROLLUP()보다 더 디테일한 결과 반환 SELECT DEPTNO, JOB, SUM(SAL) FROM EMP GROUP BY CUBE(DEPTNO, JOB) ORDER BY 1, 2; --==>> /* 10 CLERK 1300 10 MANAGER 2450 10 PRESIDENT 5000 10 (null) 8750 20 ANALYST 6000 20 CLERK 1900 20 MANAGER 2975 20 (null) 10875 30 CLERK 950 30 MANAGER 2850 30 SALESMAN 5600 30 (null) 9400 (null)ANALYST 6000 -- 모든 부서 ANALYST 직종의 급여합 (null)CLERK 4150 -- 모든 부서 CLERK 직종의 급여합 (null)M..