Query : Menghapus data Kembar di Mysql

Contoh

delete hapus from absenkaryawan hapus
inner join ( select nik, tanggal, min(id) as NoAwal
from absenkaryawan cari
 group by  nik,tanggal having count(*) > 1 ) as Cari
on   hapus.nik = Cari.nik   
and hapus.tanggal = Cari.tanggal
and hapus.id > cari.NoAwal