ASP SQL我想要达到选中某个字段并删除所有字段重复的数据

Question

选中某个字段并删除所有字段重复的数据

ASP slq 语法，("&selid&")这个是选中的数据
sql="delete from news2 where id in ("&selid&")"
sql="Delete from news2 Where news_cate in (Select news_cate from news2 Group By news_cate Having Count(*)>1)"

运行结果无法删除

我想要达到选中某个字段并删除所有字段重复的数据，上面的代码如何整合在一起？

Answer 1

Delete from news2 Where news_cate in (Select news_cate from news2 where id in ("&selid&") Group By news_cate Having Count(*)>1)