롤업

롤업을 사용하면 그룹집계를 다양하게 사용할 수 있다.

 

SELECT DEPTNO, ENAME, SAL
FROM EMP
where deptno = 10
union all
SELECT null,null,sum(sal)
FROM EMP
where deptno = 10
union all
SELECT DEPTNO, ENAME, SAL
FROM EMP
where deptno = 20
union all
SELECT null,null,sum(sal)
FROM EMP
where deptno = 20
union all
SELECT DEPTNO, ENAME, SAL
FROM EMP
where deptno = 30
union all
SELECT null,null,sum(sal)
FROM EMP
where deptno = 30

SELECT deptno, ename, sum(sal)
FROM emp
GROUP BY ROLLUP(deptno, ename);