Hi Duplicate data,

we can use SQL for delete Duplicate data ,

visit link there are many method for this : 

https://www.c-sharpcorner.com/article/5-quick-ways-to-delete-duplicate-records-from-database-which-every-developer-mus/

Let me know if  it was helpful.

Thanks

Above is only true in the simple situation that these duplicates are not yet used in your system for some purpose !  The real work will lie in first undoing everything that has already been done for these customers, and in identifying which one to keep.

I'm thinking specifically about things like 

• references from other entities will have to be rewired (maybe several of your duplicate customers have placed an order)
• Detail information : if each of these customer records have different phone number or delivery address, or banking information, or special discount code, ..., which one will you retain
• Any customer statistics gathered for marketing : how will you fix/merge that
• Any customer information already used by other systems (maybe you have sent customer key to external invoicing system, creating an external reference that will need to be fixed)

So, as @Tousif Khan said, your system should avoid getting duplicates in the first place. 

once you have them, I think, in a production setting, more will be involved than simply deleting all records except the one with the lowest id, and part of that will probably be human judgement / intervention.

Dorine

Use the duplicate file fixer tool.