要在表中查找重复项，请按这些字段分组并执行：

select id, count(*) from table group by id having count (*) > 1