SQL删除重复记录,并只保留一条

delete WeiBoTopics where Id in(select max(Id) from WeiBoTopics group by WeiBoId,Title having COUNT(*) > 1); 
原文地址:https://www.cnblogs.com/yeagen/p/4441740.html