delete from `対象テーブル`
where id not in ( select min_id from 
( select min(t1.id) as min_id from `対象テーブル` as t1
group by t1.重複確認カラム
) as t2
) ;