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

다음 문제를 풀어보세요.

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

SELECT *
FROM  (SELECT 1    NO FROM DUAL UNION ALL
       SELECT 2    NO FROM DUAL UNION ALL
       SELECT 3    NO FROM DUAL UNION ALL
       SELECT NULL NO FROM DUAL )
WHERE  NO IN ( 1, 2 );

SELECT *
FROM  (SELECT 1    NO FROM DUAL UNION ALL
       SELECT 2    NO FROM DUAL UNION ALL
       SELECT 3    NO FROM DUAL UNION ALL
       SELECT NULL NO FROM DUAL )
WHERE  NO NOT IN ( 3 );

SELECT *
FROM  (SELECT 1    NO FROM DUAL UNION ALL
       SELECT 2    NO FROM DUAL UNION ALL
       SELECT 3    NO FROM DUAL UNION ALL
       SELECT NULL NO FROM DUAL )
WHERE  NO IN ( 1, 2, NULL );

SELECT *
FROM  (SELECT 1    NO FROM DUAL UNION ALL
       SELECT 2    NO FROM DUAL UNION ALL
       SELECT 3    NO FROM DUAL UNION ALL
       SELECT NULL NO FROM DUAL )
WHERE  NO NOT IN ( 3, NULL );