Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
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.