ORACLE Minus , MSSQL Minus? Exists

오라클 마이너스

<!-- Oracle -->
SELECT aa
    FROM TABLE1
    WHERE 조건1
MINUS
SELECT aa
    FROM TABLE2
    WHERE 조건2

 

---

마소 마이너스

<!-- MSSQL -->
SELECT a.aa
  FROM (SELECT aa
          FROM TABLE1
         WHERE 조건1) a
 WHERE NOT EXISTS (SELECT 'a'
                     FROM (SELECT aa
                             FROM TABLE2
                            WHERE 조건2) b
                    WHERE a.aa = b.aa)

 

---

2013. 8. 20. 11:58