将重复的数据过滤,插入临时表,将表清空,在将临时表的数据插入表中:select field1,field2,...,fieldn into #t from table group by field1,field2,...,fieldndelete tableinsert into table select * from #t
delete from tblname where id not in (select min(id) from tblname group by 重复字段1,重复字段2,....)
into #t
from table
group by field1,field2,...,fieldndelete tableinsert into table
select *
from #t