MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


5.6.51


create table Person( id int, email varchar(50) )
insert into Person values
(1,'anne@example.com'),
(2,'cat@example.com'),
(3,'anne@example.com')
SELECT t1.*, t2.* 
  FROM Person t1 
 INNER JOIN Person t2
 WHERE t1.Email=t2.Email 
   AND t1.Id > t2.Id
 ORDER BY t1.Id, t2.Id


id
email
id
email


3
anne@example.com
1
anne@example.com


SELECT * FROM Person


id
email


1
anne@example.com

2
cat@example.com

3
anne@example.com


DELETE t1
  FROM Person t1 
 INNER JOIN Person t2
 WHERE t1.Email=t2.Email 
   AND t1.Id > t2.Id
SELECT * FROM Person


id
email


1
anne@example.com

2
cat@example.com


DELETE FROM Person
insert into Person values
(1,'anne@example.com'),
(2,'cat@example.com'),
(3,'anne@example.com')
SELECT * FROM Person


id
email


1
anne@example.com

2
cat@example.com

3
anne@example.com


DELETE t2
  FROM Person t1 
 INNER JOIN Person t2
 WHERE t1.Email=t2.Email 
   AND t1.Id > t2.Id
SELECT * FROM Person


id
email


2
cat@example.com

3
anne@example.com