-
Notifications
You must be signed in to change notification settings - Fork 4
Delete dublicate Emailss #40
-
Beta Was this translation helpful? Give feedback.
All reactions
Answered by
iamAntimPal
Mar 22, 2025
# Write your MySQL query statement below
DELETE p2 FROM Person p1
JOIN Person p2
ON p1.email = p2.email AND p1.id < p2.id;
Replies: 1 comment
-
# Write your MySQL query statement below
DELETE p2 FROM Person p1
JOIN Person p2
ON p1.email = p2.email AND p1.id < p2.id;
Beta Was this translation helpful? Give feedback.
All reactions
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