질문 ※ emp 테이블 정보가 당장 없어 union all 을 이용해서 가상의 emp 테이블 생성했습니다. with emp as ( select 'Jane' ename, 1 as deptno, 100 as sal from dual union all select 'Shawn' ename, 1 as deptno, 200 as sal from dual union all select 'Ted' ename, 1 as deptno, 250 as sal from dual union all select 'steve' ename, 2 as deptno, 700 as sal from dual union all select 'John' ename, 2 as deptno, 600 as sal from dual ) select..