Yasser Oracle Blog Dive in Oracle with Yasser, Oracle Developer Courses
DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3);