[原创]删除重复记录的另一种方法
while exists (select count(*) from tablea group by col1 having count(*)>1 )
begin
delete top (1) from tablea where col1 in(
select col1 from tablea
group by col1 having count(*)>1
)
end
begin
delete top (1) from tablea where col1 in(
select col1 from tablea
group by col1 having count(*)>1
)
end
