오라클공부 396. Scalar Subquery

Scalar Subquery

 

1) Select List에서의 Scalar Subquery

 

SELECT employee_id, last_name,                (                  SELECT department_name                  FROM departments d                 WHERE e.department_id = d.department_id                  ) department_name   FROM employees e ORDER BY department