Link Search Menu Expand Document

196. Delete Duplicate Emails

Solution Code

MySQL

DELETE a
FROM Person a, Person b
WHERE a.Email = b.Email AND
      a.Id > b.Id;

© 2023. All rights reserved.