mysql去重，根据唯一字段来去重保留任一条

DELETE   FROM    `gov_departmental_documents`    WHERE title IN (
SELECT  a.title   FROM  (SELECT title FROM gov_departmental_documents GROUP BY title HAVING COUNT(title) > 1) AS a)
AND id NOT IN (SELECT  b.aa FROM (SELECT min(id) AS aa FROM gov_departmental_documents GROUP BY title HAVING COUNT(title) > 1) AS b);