SyntaxFix
Write A Post
Hire A Developer
Questions
This might help in your case
DELETE t1 FROM table t1 INNER JOIN table t2 WHERE t1.id > t2.id AND t1.col1 = t2.col1