56,677
社区成员
发帖
与我相关
我的任务
分享
select name from test where name
in(SELECT name FROM test group by name having count(name)=2)
mysql> select * from test;
+------+
| name |
+------+
| a |
| a |
| b |
| b |
| c |
| d |
| e |
| e |
| f |
| g |
| g |
| h |
+------+
12 rows in set (0.03 sec)
mysql> select name
-> from test a
-> where 2=(select count(*) from test where name=a.name);
+------+
| name |
+------+
| a |
| a |
| b |
| b |
| e |
| e |
| g |
| g |
+------+
8 rows in set (0.09 sec)
mysql>