转载于http://blog.csdn.net/ivan0609/article/details/8257626
下面是这个错误的解决办法,先找出表中重复的数据,然后删除相同数据rowid最小的那一列
- select * from material_table
- where unid in (select unid from material_table group by unid having count(unid) > 1)
这里的unid 是主键列,通过主键进行分组查找出记录大于1条的数据。
找到重复数据后进行删除
delete from material_table
where unid in (select unid from material_table group by unid having count(unid) > 1)
and rowid not in (select min(rowid) from material_table group by unid having count(unid)>1)