mysql 中删除某个字段重复的SQL语句

delete evalustion as a from evaluation as a ,
(select * from evaluation group by month having count(1) > 1) 
as b where a.month = b.month and a.id <> b.id;