问题:
表如下:
------------------------------------------------------------
*
1
2
3
5
5
7
7
8
9
只显示,5,5,7,7出来,不显示别的。(注:不只是 5 7 只要重复的都要 输出)
建表:
create table doubleprint (id integer not null);
insert into doubleprint values (1) ,(2),(3), (4),(5),(4),(1),(7), (9),(4),(3),(11);
解答Sql:
select id from doubleprint where (select count(id) from doubleprint a where doubleprint.id = a.id) > 1 ;
结果:
+------+
| id |
+------+
| 3 |
| 4 |
| 1 |
| 4 |
| 4 |
| 3 |
| 1 |
| 1 |
+------+