查找重复数据并删除？

[ideasky]

select Title from News group by Title having count(1)>1
我用这个语句查找可以，接下来如何删除呢？

[dawugui]

select Title from News group by Title having count(1)>1
我用这个语句查找可以，接下来如何删除呢？
-----------------
delete news from news t where title in (select Title from News group by Title having count(1)>1 )

[girl5201314]

除了Title關鍵值外，有沒有其他關鍵值？
沒有的話，恐怕就不好刪了。

重新建個表，設定Title唯一，把數據重新導一邊

[ailin84]

我用过这样删：

delete from News where id in (
select id from (SELECT max(id) as id,count(Title) as num FROM News group by Title) as b where num>1
)