I was able to learn how to manipulate DML with subqueries! At first, I only thought of a single where clause like delete b from Person a, Person b where a.id<b.id AND a.email = b.email . If you use the join operation, you can do more complex operations:)