筛出选择相同产品的用户，怎样写sql？

[thishaha]

用户 选择产品
A p1
A p2
A p3
B p1
B p2
C p3
C p2
C p1

怎么筛出选择了p1,p2,p3的用户？本例即选出A用户和C用户

[thishaha]

已经查到了，进来的给分了

[wolfwu_kg5]

select 用户
from TABLE
where 产品 in ('p1','p2','p3')
group by 用户 having count(distinct(产品)) > 2

[嘻哈大咖秀]

那来混点分分

[WWWWA]

SELECT * FROM TTY A WHERE EXISTS(SELECT 1 FROM TTY WHERE A.用户=用户 AND 选择产品='P2') AND EXISTS(SELECT 1 FROM TTY WHERE A.用户=用户 AND 选择产品='P3') AND 选择产品='P1'