MYSQL剔除重复记录的特殊方法

MYSQL删除重复记录的特殊方法
DELETE test AS a FROM test AS a,(SELECT *, min(id) FROM test GROUP BY NAME HAVING count(1)> 1)AS b WHERE a. NAME = b. NAME AND a.id > b.id;