Removing duplicate rows from table in Oracle <p>I'm testing something in Oracle and populated a table with some sample data, but in the process I accidentally loaded duplicate records, so now I can't create a primary key using some of the columns.</p> <p>How can I delete all duplicate rows and leave only one of them?</p>