By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE review (
review_id INTEGER PRIMARY KEY,
status_id INTEGER
);
CREATE TABLE review_detail (
detail_id INTEGER PRIMARY KEY,
review_id INTEGER,
title TEXT,
nickname TEXT
);
INSERT INTO review VALUES (1, 2);
INSERT INTO review VALUES (2, 2);
INSERT INTO review VALUES (3, 2);
INSERT INTO review VALUES (4, 2);
INSERT INTO review VALUES (5, 2);
INSERT INTO review_detail VALUES (1, 1, 'Test Title', 'Test nickname');
INSERT INTO review_detail VALUES (2, 2, 'Test Title', 'Test nickname');
INSERT INTO review_detail VALUES (3, 3, 'Test Title', 'Test nickname');
INSERT INTO review_detail VALUES (4, 4, 'Test Title222', 'Test nickname333');
INSERT INTO review_detail VALUES (5, 5, 'Test Title111', 'Test nickname111');
SELECT * FROM `review`;
SELECT * FROM `review_detail`;
| review_id | status_id |
|---|---|
| 1 | 2 |
| 2 | 2 |
| 3 | 2 |
| 4 | 2 |
| 5 | 2 |
| detail_id | review_id | title | nickname |
|---|---|---|---|
| 1 | 1 | Test Title | Test nickname |
| 2 | 2 | Test Title | Test nickname |
| 3 | 3 | Test Title | Test nickname |
| 4 | 4 | Test Title222 | Test nickname333 |
| 5 | 5 | Test Title111 | Test nickname111 |
DELETE t1
FROM review_detail t1
JOIN review_detail t2 USING (title, nickname)
WHERE t1.detail_id < t2.detail_id;
SELECT * FROM `review_detail`;
| detail_id | review_id | title | nickname |
|---|---|---|---|
| 3 | 3 | Test Title | Test nickname |
| 4 | 4 | Test Title222 | Test nickname333 |
| 5 | 5 | Test Title111 | Test nickname111 |