20209 9월 28일에 가서 이거 확인할것.

 SELECT dept.dname, emp.job , sum(emp.sal + NVL(comm , 0))sal

FROM emp , dept

WHERE emp.deptno = dept.deptno  

GROUP BY ROLLUP (dname, job ) ;  

정답 

두번째 

SELECT * 

FROM dept

WHERE deptno ( SELECT deptno   

               FROM emp 

               WHERE emp.deptno != dept.deptno 

SELECT *

FROM dept

WHERE deptno NOT IN ( SELECT deptno 

                       FROM emp ) ; 

이 두쿼리가 같나????????????