1.查询重复记录
select * from 表名
where
2.删除保留一条重复记录
delete from 表名
where
and
例子: role表中有两个字段,id,name
delete from role
where name in (select a.name from (select name from role group by name having count(name) > 1) a)
and id not in (select b.id from(select min(id) id from role group by name having count(name)>1) b)