[Leetcode] Delete duplicate emails

Link: https://leetcode.com/problems/delete-duplicate-emails/

Question:
Write a SQL query to delete all duplicate email entries in a table named person, keeping only unique emails based on its smallest ID.

+ -- + ------ +
| ID | email |
+ -- + ------ +
| 1 | [email protected] |
| 2 | [email protected] |
| 3 | [email protected] |
+ -- + ------ +
ID is the primary key column for this table.
For example, after running your query, the above person table shocould have the following rows:

+ -- + ------ +
| ID | email |
+ -- + ------ +
| 1 | [email protected] |
| 2 | [email protected] |
+ -- + ------ +

Ideas:
Pay attention to the query structure Usage After Delete.

Algorithm:

DeleteP1FromPerson p1Inner JoinPerson p2OnP1.email = p2.emailAndP1.id> p2.id
 

[Leetcode] Delete duplicate emails