Remove Duplicate Records from MySQL Server

DELETE S1 FROM table_name AS S1  
INNER JOIN table_name AS S2   
WHERE S1.id > S2.id AND S1.email = S2.email;  
Latest posts by Amardeep Dubey (see all)

Leave a Reply