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

다음 문제를 풀어보세요.

다음 보기 중 아래 SQL과 실행결과가 다른 것을 고르시오.

SELECT DEPT_ID, SALARY 
FROM   EMP
WHERE (DEPT_ID, SALARY) IN ( (10, 3000), (20, 4000) );

SELECT DEPT_ID, SALARY 
FROM   EMP
WHERE (DEPT_ID = 10 AND SALARY = 3000)
   OR (DEPT_ID = 20 AND SALARY = 4000);

SELECT DEPT_ID, SALARY 
FROM   EMP
WHERE  DEPT_ID IN (10, 20)
AND    SALARY  IN (3000, 4000);

SELECT DEPT_ID, SALARY 
FROM   EMP
WHERE  DEPT_ID || SALARY IN ( '103000', '204000' );

SELECT DEPT_ID, SALARY 
FROM   EMP
WHERE  DEPT_ID = 10 AND SALARY = 3000
UNION  ALL
SELECT DEPT_ID, SALARY 
FROM   EMP
WHERE  DEPT_ID = 20 AND SALARY = 4000;