VIVEK PANDHARKAR Uncategorized Delete Duplicate rows in SQL Table

Delete Duplicate rows in SQL Table

Categories:

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/