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)
- Remove Duplicate Records from MySQL Server - October 12, 2021
- How to Secure Your Apache Server - September 10, 2021
- Linux security - September 9, 2021