# #196 Delete Duplicate Emails

#### [https://leetcode.com/problems/delete-duplicate-emails](https://leetcode.com/problems/delete-duplicate-emails)

{% tabs %}
{% tab title="MS SQL Server" %}
```sql
DELETE P2 
FROM Person P1, Person P2
WHERE P1.Email = P2.Email
AND P1.Id < P2.Id;
```
{% endtab %}
{% endtabs %}
