Understanding the Difference between Two DELETE Statements in Oracle

Drop Duplicates in a Pandas DataFrame Based on Values in Other Columns