Skip to content

Delete dublicate Emailss #40

Answered by iamAntimPal
Antim-IWP asked this question in Q&A
Delete dublicate Emailss #40
@Antim-IWP Antim-IWP
Mar 21, 2025 · 1 comment
Answered by iamAntimPal Return to top

Antim-IWP
Mar 21, 2025
Collaborator

You must be logged in to vote
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;

EXPLANATION

View full answer

Replies: 1 comment

iamAntimPal
Mar 22, 2025
Maintainer

You must be logged in to vote
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
Category
Q&A
Labels
question Further information is requested
2 participants
@Antim-IWP @iamAntimPal