241017 TIL

SQL 문법

집합연산

(1) A ∩ B

-- 교집합
SELECT * FROM member_A
INTERSECT 
SELECT * FROM member_B

(2) A- B

-- 차집합
SELECT * FROM member_A 
MINUS
SELECT * FROM member_B

(3) A ∪ B

-- 합집합
SELECT * FROM member_A
UNION
SELECT * FROM member_B