1、查询重复数据
2、删除重复数据(rowid只限于Oracle)
3、mysql中可以自建一个字段为rowid的自增字段 然后根据rowid字段去进行删除
select * from people
where peopleid in (select peopleid from people group by peopleid having count(peopleid)>1)
2、删除重复数据(rowid只限于Oracle)
delete from people
where peopleid in (select peopleid from people group by peopleid having count(peopleid)>1)
and rowid not in (select min(rowid) from people group by peopleid having count(peopleid)>1)
3、mysql中可以自建一个字段为rowid的自增字段 然后根据rowid字段去进行删除
delete from people
where peopleId in (SELECT a.peopleid FROM
(select peopleId from people group by peopleId having count(peopleId) > 1) a)
and rowid not in (SELECT b.rowid FROM
(select MIN(rowid) rowid from people group by peopleId having count(peopleId )>1) b)