Question

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

例：
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表 WHERE sid=W.sid and s_name=W.s_name group by s_id,s_name having count(*)>=2)

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