How to delete duplicate records in service offering(service_offering)

Hi Team,

i have requirement to delete duplicate records 

but need to check name, parent and service classification

for eg: if i have data name as abc parent as yzi and service classificaition as business service

and if i have data name as abc parent as yzi and service classificaition as techinical service

need to return data 

and if i have data name as abc parent as yzi and service classificaition as business service

and if i have data name as abc parent as yzi and service classificaition as business service

need to delete 

please advice