查找本表重复数据和删除重复数据

DELETE from NT_News where id in (
Select max(id) From NT_News Group By NewsTitle Having Count(*) > 1)

SELECT * from NT_News where id in (
Select max(id) From NT_News Group By NewsTitle Having Count(*) > 1)