有碰过这个问题,有想过解决的方法,一直没心情坐下来写,现在有空研究一下:<br><br>delete from table1<br>where field1 in (select field1 from table1 group by field1 having count(*)>1)<br>and field2 in (select field2 from table1 group by field2 having count(*)>1)<br>....//可以判断重复的字段尽可能写多1、2个...<br>and id not in <br>(select id1 as id from<br>(select min(id) as id1,field1,field2,.... from table1 group by field1,field2,.... havinf count(*)>1)<br>)<br><br>帮忙调试一下,发表一下意见!谢谢