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;