Published May 06, 2023
[
 
]
id | word | created_at |
---|---|---|
1 | hello | 2023-05-05 10:12:13 |
2 | hello | 2023-05-05 10:12:13 |
3 | hello | 2023-05-05 10:12:13 |
4 | dog | 2023-05-05 10:12:13 |
5 | dog | 2023-05-05 10:12:13 |
6 | cat | 2023-05-05 10:12:13 |
We want to have resulted data like
id | word | created_at |
---|---|---|
1 | hello | 2023-05-05 10:12:13 |
4 | dog | 2023-05-05 10:12:13 |
6 | cat | 2023-05-05 10:12:13 |
DELETE FROM words WHERE id NOT in (
SELECT MIN(id) FROM words GROUP BY word
);