#196 Delete Duplicate Emails

https://leetcode.com/problems/delete-duplicate-emails

MS SQL Server

DELETE P2 
FROM Person P1, Person P2
WHERE P1.Email = P2.Email
AND P1.Id < P2.Id;