_196. Delete Duplicate Emails.md

196. Delete Duplicate Emails

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : June 07, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 62.9 %

---

Solutions

• e196.py
• e196.sql

Python

e196.py

import pandas as pd

def delete_duplicate_emails(person: pd.DataFrame) -> None:
    person.sort_values(by='id', inplace=True)
    person.drop_duplicates(subset='email', keep='first', inplace=True)

SQL

e196.sql

# Write your MySQL query statement below
DELETE largerRepeat 
FROM Person largerRepeat, Person smallerRepeat 
WHERE largerRepeat.id > smallerRepeat.id 
    AND largerRepeat.email = smallerRepeat.email