比如你的表名叫aa，bb是临时空表
select distinct * from aa into bb
drop aa
select * from bb into aa
drop bb
select distinct * into TB2 from TB1
delete from TB1 where TB1.唯一字段 in (select 唯一字段 from TB2)
INSERT INTO TB1
select * from TB2
直接在表中删除去，我汗，怎么会有相同的行呢，你数据库的表没设置主键外键么
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024