hariprasadraja
10/10/2019 - 3:58 AM

sql delete duplicate records and keep lowest ID

delete-duplicate.mysql
content_copyfile_download
DELETE c1 FROM contacts c1
INNER JOIN contacts c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;