[MYSQL] INTERSECT (교집합)

https://school.programmers.co.kr/learn/courses/30/lessons/62284

프로그래머스

 

• INTERSECT 사용 쿼리

SELECT CART_ID
FROM CART_PRODUCTS 
WHERE NAME = 'Milk'
INTERSECT
SELECT CART_ID
FROM CART_PRODUCTS
WHERE NAME = 'Yogurt'
ORDER BY CART_ID

 

Milk와 Yogurt를 각각 선택하고 있는 두 쿼리의 교집합을 구한다.

 

 

• GROUP BY, HAVING 사용 쿼리

SELECT CART_ID
FROM CART_PRODUCTS 
WHERE NAME IN ('Milk', 'Yogurt')
GROUP BY CART_ID
HAVING COUNT(DISTINCT NAME) = 2
ORDER BY CART_ID