# 196. 删除重复的电子邮箱
# https://leetcode-cn.com/problems/delete-duplicate-emails/

# SQL架构
Create table If Not Exists Person (Id int, Email varchar(255));
Truncate table Person;
insert into Person (id, email) values ('1', 'john@example.com');
insert into Person (id, email) values ('2', 'bob@example.com');
insert into Person (id, email) values ('3', 'john@example.com');

# Please write a DELETE statement and DO NOT write a SELECT statement.
# Write your MySQL query statement below
delete p1
from
    Person p1,
    Person p2
where
    p1.Email = p2.Email
    and p1.Id > p2.Id;

# clean-up
drop table Person;