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

时间：2015-04-20 16:29:16 收藏：0 阅读：253

delete WeiBoTopics where Id in(select max(Id) from WeiBoTopics group by WeiBoId,Title having COUNT(*) > 1);

原文：http://www.cnblogs.com/yeagen/p/4441740.html