1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
代码如下:
select * from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1) 2、删除表中
create table tmp SELECT * from lhb t where t.id not in (select max(id) from lhb group by code,date,reason);
delete from lhb where id in(select id from tmp);
drop table tmp;mysql无法进行子查询删除，使用新建一个临时表，删
首先用户要对数据库有完全的权限，创建，删除表create table bak as (select * from cdb_threads group by subject having count(*)=1);创建一个数据库，把未重复的提取出来insert into bak (select * from cdb_threads group by subject having count(*)>
