SQLD CBT 기출문제 예상문제 416번

다음 문제를 풀어보세요.

다음 보기 중 실행 결과 값이 다른 SQL을 고르시오.

[테이블 정보]

SELECT EMPNO FROM EMP WHERE DEPTNO = 10
UNION
SELECT EMPNO FROM EMP WHERE DEPTNO = 20

SELECT EMPNO FROM EMP WHERE DEPTNO IN (10, 20)

SELECT EMPNO FROM EMP WHERE DEPTNO = 10
UNION ALL
SELECT EMPNO FROM EMP WHERE DEPTNO = 20

SELECT EMPNO FROM EMP WHERE DEPTNO = 10
INTERSECT
SELECT EMPNO FROM EMP WHERE DEPTNO = 20