DELETE t1 FROM students t1
INNER JOIN students t2
WHERE
t1.UserID > t2.UserID AND
t1.Email = t2.Email;
Reference: https://www.mysqltutorial.org/mysql-delete-duplicate-rows/
Delete Duplicate rows in SQL Table
Categories:
The Stack Developer
DELETE t1 FROM students t1
INNER JOIN students t2
WHERE
t1.UserID > t2.UserID AND
t1.Email = t2.Email;
Reference: https://www.mysqltutorial.org/mysql-delete-duplicate-rows/