0196-delete-duplicate-emails.sql

-- 196. Delete Duplicate Emails
-- https://leetcode.com/problems/delete-duplicate-emails

-- 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
;