더보기 ▣오늘의 주요 키워드▣ INLINE VIEW PIVOT, UNPIVOT [문제66] Executive 부서이름의 소속된 모든 사원에 대한 department_id, last_name, job_id 출력하세요. 1)서브쿼리 select department_id, last_name, job_id from employees where department_id = (select department_id from departments where department_name ='Executive'); 2)join select e.department_id, last_name, job_id from employees e, departments d where e.department_id = d.department..
