Oracle

[oracle] 중복제거 서브쿼리

inspitus 2007. 6. 11. 20:46
select t.employee_id, t.last_name, t.department_id
from employees t
where 2<(select count(e.department_id)
               from employees e
               where t.department_id=e.department_id);