select * from 表名 group by 字段1,字段2 having count(*)>1

（显示重复）