Postgres 14

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

Create Table dat(ID INT, DATE_PUBLISHED timestamp, DATE_LAST_MODIFIED timestamp);

Insert Into dat Values(7,'2019-12-11 13:15','2019-09-19 13:40'),
(7,'2019-12-11 13:15','2022-07-11 21:15'),
(8,'2019-12-11 13:15','2019-09-19 13:40'),
(8,'2019-12-11 13:15','2019-09-20 13:40'),
(8,'2019-12-11 13:15','2019-09-21 13:40'),
(8,'2019-12-11 13:15','2019-09-22 13:40');

CREATE TABLE



INSERT 0 6


DELETE FROM
dat T WHERE EXISTS (SELECT 1 FROM dat D
                    WHERE T.id = D.id AND
                            T.date_last_modified < D.date_last_modified
                   )

DELETE 4


select * from dat


id
date_published
date_last_modified


7
2019-12-11 13:15:00
2022-07-11 21:15:00

8
2019-12-11 13:15:00
2019-09-22 13:40:00



SELECT 2

id	date_published	date_last_modified
7	2019-12-11 13:15:00	2022-07-11 21:15:00
8	2019-12-11 13:15:00	2019-09-22 13:40:00