SQL 查询一个表中 两个字段数量都大于2条记录的数据

Question

例：
A表
sn s_id s_name 字段3
1 101 101 aaa
2 101 101 bbb
3 102 102 ccc
4 102 112 ddd
5 103 103 eee

得到结果
sn s_id s_name 字段3
1 101 101 aaa
2 101 101 bbb

求高手解答，在线等。。。。。

Answer 1

SELECT *
FROM A表 W
WHERE EXISTS(SELECT s_id,s_name FROM A表 WHERE sid=W.sid and s_name=W.s_name group by s_id,s_name having count(*)>=2)追问

出来了 刚写错了，谢谢

本回答被提问者采纳

Answer 2

SELECT *
FROM A表 W
WHERE EXISTS(SELECT s_id,s_name FROM A表 group by s_id,s_name having count(*)>=2)