MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE people
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(40) NOT NULL DEFAULT '',
age INT NOT NULL DEFAULT 0,
phrase VARCHAR(40) NOT NULL DEFAULT '',
PRIMARY KEY (id)
);

INSERT INTO people(name, age, phrase) VALUES ('John Doe', 25, 'qwert'), ('William Smith', 19, 'yuiop'),
('Peter Jones', 19, 'yuiop'), ('Ronnie Arbuckle', 32, 'asdfg'), ('Ronnie Arbuckle', 32, 'asdfg'),
('Mary Evans', 18, 'hjklp'), ('Mary Evans', 18, 'hjklpd'), ('John Doe', 25, 'qwert');

SELECT * FROM people;


id
name
age
phrase


1
John Doe
25
qwert

2
William Smith
19
yuiop

3
Peter Jones
19
yuiop

4
Ronnie Arbuckle
32
asdfg

5
Ronnie Arbuckle
32
asdfg

6
Mary Evans
18
hjklp

7
Mary Evans
18
hjklpd

8
John Doe
25
qwert


DELETE t1
FROM people t1
JOIN people t2 USING (name,age,phrase)
WHERE t1.id > t2.id;
SELECT * FROM people;


id
name
age
phrase


1
John Doe
25
qwert

2
William Smith
19
yuiop

3
Peter Jones
19
yuiop

4
Ronnie Arbuckle
32
asdfg

6
Mary Evans
18
hjklp

7
Mary Evans
18
hjklpd

id	name	age	phrase
1	John Doe	25	qwert
2	William Smith	19	yuiop
3	Peter Jones	19	yuiop
4	Ronnie Arbuckle	32	asdfg
5	Ronnie Arbuckle	32	asdfg
6	Mary Evans	18	hjklp
7	Mary Evans	18	hjklpd
8	John Doe	25	qwert