![[SQL 문제 풀이] 재구매가 일어난 상품과 회원 리스트 구하기](https://image.inblog.dev?url=https%3A%2F%2Fsource.inblog.dev%2Ffeatured_image%2F2024-11-17T07%3A15%3A11.854Z-ad6a4737-95fa-48b4-98b3-55fcc7129015&w=3840&q=75)
SELECT user_id, product_id
FROM online_sale
GROUP BY user_id , product_id
HAVING COUNT(*) > 1
ORDER BY user_id ASC , product_id DESC;GROUP BY를 활용해 중복을 처리
Share article
SELECT user_id, product_id
FROM online_sale
GROUP BY user_id , product_id
HAVING COUNT(*) > 1
ORDER BY user_id ASC , product_id DESC;