查找相同数据SQL: 记录一下第一篇博客 table:表名 name:字段名 select * from table where name in (select name from table group by name having count(name) > 1);