Postgres 13

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

CREATE TABLE dups(
   ID INT,
   creation_date VARCHAR(50),
   col1 VARCHAR(50),
   col2 VARCHAR(50),
   col3 VARCHAR(50)
);

				
INSERT INTO dups VALUES (1,'21 April','a','b','e');
INSERT INTO dups VALUES (2,'23 April','a','b','e');
INSERT INTO dups VALUES (3,'21 April','c','d','e');
1 rows affected

1 rows affected

1 rows affected

DELETE 
FROM dups t
WHERE EXISTS (SELECT 1 
               FROM dups tt
               WHERE tt.col1 =  t.col1
               AND tt.col2 =  t.col2
               AND tt.col3 =  t.col3
               HAVING MIN(tt.ctid) <> t.ctid
               ); 
1 rows affected

SELECT * FROM dups


id
creation_date
col1
col2
col3


1
21 April
a
b
e

3
21 April
c
d
e