选中某个字段并删除所有字段重复的数据
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)"
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)"
Delete from news2 Where news_cate in (Select news_cate from news2 where id in ("&selid&") Group By news_cate Having Count(*)>1)