deletefrom people where peopleId in (select peopleId from people groupby peopleId havingcount(peopleId) > 1) and rowid notin (selectmin(rowid) from people groupby peopleId havingcount(peopleId )>1)
deletefrom vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae groupby peopleId,seq havingcount(*) > 1) and rowid notin (selectmin(rowid) from vitae groupby peopleId,seq havingcount(*)>1)
select * from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1) and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
查找所有重复标题的记录:[sql] view plain copySELECT * FROM t_info a WHERE ((SELECT COUNT(*) FROM t_info WHERE Title = a.Title) > 1) ORDER BY Title DESC 一、查找重复记录1、查找全部重复记