1sql语句:
while 1=1 - - 启动无穷循环
begin
delete top(1) from aaa(表名) - - 一次删除一行数据
where myname in (select myname from aaa
group by myname
having count(*)>1) --仅删除重复数据
if @@ROWCOUNT=0 BREAK - -判断最近删除行数
end
测试
select * from aaa
2 select distinct myname from aaa