[导入]通过SQL语句删除重复记录

select  max(groupId) as groupID ,threadId  from tbl_ThreadInfo_bak  where threadID in(
select threadID from tbl_ThreadInfo_bak group by threadID having count(*)>1
)

group by threadID

 

感谢网友"子风"提供此方法!!

文章来源:http://hanxianlong888.blog.163.com/blog/static/21390252007715105335395