Delete duplicate rows MySql

02/12/2020

DELETE t2 FROM 'table' t1
INNER JOIN 'table' t2 
WHERE
    t2.id > t1.id AND 
    t1.user = t2.user AND	
    t1.email = t2.email;