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 | |
---|---|
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 should have the following rows:
Id | |
---|---|
1 | [email protected] |
2 | [email protected] |
Note:
Your output is the whole Person table after executing your sql. Use delete statement.
delete `p1` from `Person` `p1`, `Person` `p2` where
`p1`.`Email` = `p2`.`Email`
and `p1`.`Id` > `p2`.`Id`;
If you have a better solution, you can star and fork Leetcode-database-problem then create a pull request.