我在sql 2008写的代码，出错了要怎么改？
delete a from tb1 a join (select name,count(*) from tb1 group by name having COUNT (*)>1) b on a.name=b.name where a.ID<b.ID;
2 回答
...举报
0/150
提交
取消
delete a from tb1 a join (select name,count(*) from tb1 group by name having COUNT (*)>1) b on a.name=b.name where a.ID<b.ID;
2016-05-09
举报
