SQLD 벼락치기 5부 · 08 문제 44

QUESTION44

다중칼럼 IN → EXISTS

아래 SQL의 실행 결과와 동일한 것은?

제시 SQL

SELECT * FROM T1
WHERE (T1.C1, T1.C2)
  IN (SELECT T2.C1, T2.C2
      FROM T2
      WHERE T2.C3 < 200);

①

SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T2 WHERE T1.C1 = T2.C1 AND T1.C2 = T2.C2 AND T2.C3 < 200);

②

SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T2 WHERE T1.C1 = T2.C1 AND T1.C2 = T2.C2 OR T2.C3 < 200);

③

SELECT * FROM T1 WHERE NOT EXISTS (SELECT 1 FROM T2 WHERE T1.C1 = T2.C1 AND T1.C2 = T2.C2 AND T2.C3 >= 200);

④

SELECT * FROM T1 WHERE NOT EXISTS (SELECT 1 FROM T2 WHERE T1.C1 = T2.C1 AND T1.C2 = T2.C2 OR T2.C3 >= 200);