Content-Length: 285264 | pFad | http://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/40

5A Delete dublicate Emailss · iamAntimPal LeetCode_SQL_Database · Discussion #40 · GitHub

Delete dublicate Emailss #40

Answered by iamAntimPal

Antim-IWP asked this question in Q&A

Antim-IWP
Mar 21, 2025
Collaborator

196. Delete Duplicate Emails

Answered by iamAntimPal

# Write your MySQL query statement below
DELETE p2 FROM Person p1 
JOIN Person p2 
ON p1.email = p2.email AND p1.id < p2.id;

View full answer

Replies: 1 comment

iamAntimPal
Mar 22, 2025
Maintainer

# Write your MySQL query statement below
DELETE p2 FROM Person p1 
JOIN Person p2 
ON p1.email = p2.email AND p1.id < p2.id;

0 replies

Answer selected by Antim-IWP

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment