mysql - 使用 mysql 显示临时表中每个组的重复项

Question

有人可以帮助我进行 mysql 查询，以使用 mysql 显示临时表中每个组的重复项

sqlfiddle http://sqlfiddle.com/#!2/d8c9c/17

表格

TOWN    ID1
town1   1
town1   1
town1   4
town2   1
town2   5
town2   8
town3   1
town3   3
town3   3

所需结果

TOWN    ID1
town1   1
town1   1
town3   3
town3   3

我尝试过 SELECT * FROM Table1 group by TOWN,ID1但这会删除重复项并显示非重复记录

Answer 1

这是您要查找的查询

SELECT TOWN, ID1  FROM Table1 t WHERE ( SELECT COUNT(*) FROM Table1 WHERE TOWN = t.TOWN AND ID1 = t.ID1 ) > 1;