Oracle

Set Operator Sample.

Figo Kim 2006. 9. 1. 22:18
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
SELECT employee_id, department_id
FROM employee_id
WHERE (employee_id, department_id)
IN(SELECT employee_id, department_id
FROM employees
{UNION|UNION ALL|INTERSECT|MINUS}
SELECT employee_id, department_id
FROM job_history);


'Oracle' 카테고리의 다른 글

How to use dummy column?  (0) 2006.09.01
How to use dummy column?  (0) 2006.09.01
Set Operator Sample.  (0) 2006.09.01
Multiple operator..  (0) 2006.09.01
Multiple operator..  (0) 2006.09.01