#sql语句查询一张表中某字段值重复记录的数据
select * from 表名 as(起别名) t where t.name in (select name from 表名 group by name having count(name) > 1);
##显示结果
#sql语句查询一张表中某字段值重复记录的数据
select * from 表名 as(起别名) t where t.name in (select name from 表名 group by name having count(name) > 1);
##显示结果