教你SQL语句删除重复记录 （1）

select [标志字段id],count(*) into temp1 from [表名]
group by [标志字段id]
having count(*)>1

insert temp1
select [标志字段id],count(*) from [表名]
group by [标志字段id]
having count(*)=1

select * into temp2 from [表名]
where 标志字段id in(select 标志字段id from temp1)

insert [表名]
select * from temp2

drop table temp1
drop table temp2

declare @max integer,@id integer
declare cur_rows cursor local for 
select id,count(*) from 表名 group by id having count(*) > 1
open cur_rows
fetch cur_rows into @id,@max
while @@fetch_status=0
begin
select @max = @max -1
set rowcount @max
delete from 表名 where id = @id
fetch cur_rows into @id,@max
end
close cur_rows
set rowcount 0