删除重复记录 delete from yourtable where max(rowid)!=(select max(rowid) from yourtable aa where aa.name=yourtable.name and aa.price=yourtable.price and aa.number=yourtabel.number)
刚才有误 delete from yourtable where max(rowid)!=改为 delete from yourtable where yourtabel.rowid!=
检测重复记录(假设你的表名为a) select * from a where a.rowid!=(select max(rowid) from a b where a.name=b.name and a............同上)
delete from yourtable where max(rowid)!=(select max(rowid) from yourtable aa
where aa.name=yourtable.name and aa.price=yourtable.price and aa.number=yourtabel.number)
delete from yourtable where max(rowid)!=改为
delete from yourtable where yourtabel.rowid!=
select * from a where a.rowid!=(select max(rowid) from a b where a.name=b.name
and a............同上)