MS SQL 删除重复记录
delete from [表名] where
CONVERT(varchar(100), rq, 20) in (select CONVERT(varchar(100), rq, 20) from [表名] group by xm,CONVERT(varchar(100), rq, 20) having count(*)>1)
and ID not in( select min(id) from [表名] group by xm,CONVERT(varchar(100), rq, 20) having count(*)>1)
这篇文档对您是否有帮助?