디비총마무리
select deptno,ename,sum(sal)from empgroup by rollup(deptno,ename); select deptno,ename,sum(sal)from empgroup by deptno,enameunion allselect deptno,to_char(null) as ename,sum(sal)from empgroup by deptnounion allselect to_number(null) as deptno,to_char(null) as ename, sum(sal)from emporder by deptno,ename; select deptno,ename,sum(sal)from empgroup by grouping sets((deptno,ename),(deptno)); select ..
더보기