Delete dublicate Emailss #40

Antim-IWP · 2025-03-21T21:59:07Z

Antim-IWP
Mar 21, 2025
Collaborator

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

iamAntimPal · 2025-03-22T09:00:05Z

# 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