mysql delete from multiple coulmn

## Create temproray table by picking min duplicate id and delete
delete table from table inner join 
    (select  min(id) minid, sample_data, sample_data1, sample_data2
     from table 
     group by ssample_data, sample_data1
     having count(1) > 1) as duplicates
   on (duplicates.minid = search_search.id)
   

## Keep only duplicate entry and delete rest
delete table from table inner join 
    (select  min(id) minid, sample_data, sample_data1, sample_data2
     from table 
     group by sample_data, sample_data1
     having count(1) > 1) as duplicates
   on (
   duplicates.sample_data = search_search.sample_data
   duplicates.minid <> search_search.id
   )