

delete from tabelle where id in ( 
  select    b.rowid, b.last_name, b.employee_id 
  from      copy_employees a 
  left join copy_employees b on (b.employee_id = a.employee_id) and (b.rowid > a.rowid) 
  where     (b.rowid is not null) 
)