Subquery 쿼리 구문 안에 쿼리문. group by절 이외에 모두 가능함 select 컬럼명 from 테이블명 where 조건 (select 컬럼명 from 테이블명) 예시 select last_name, salary from employees where salary > (select salary from employees where last_name = 'Abel'); select last_name, job_id, salary from employees where salary = (select min(salary) from employees); select department_id, min(salary) from employees group by department_id having min(sal.....
