mysql 刪掉重復數據

--不知道為啥這個mysql外邊還要包一層，不然就報錯
DELETE
FROMcourse  
WHEREname IN (
select mm.name from (SELECTa.name  as nameFROMcourse aGROUP BYa. NAMEHAVINGcount(a.NAME) > 1)mm)
AND  id NOT IN (
select nn.id from (SELECTmin(id) as idFROMcourse aGROUP BYa. NAMEHAVINGcount(a.NAME) > 1)nn
);

?