delete from people
where rowid in (select min(rowid) from people group by peopleId having count(peopleId )>1)
delete from people
where rowid in (select min(rowid) from people group by peopleId having count(peopleId )>1)
转载于:https://www.cnblogs.com/macT/p/10865224.html