In Oracle, each record has a RowID. RowID is unique in the entire database, and the RowID determines which data file, block, line on the Oracle; in a repetitive record, maybe all The contents of the columns are the same, but the RowId will not be the same, so as long as it is determined that the maximum ROWID has the maximum ROWID, the rest is removed.
Implementation: SQL> Create Table Test
2 Name Varchar (50), 3 Sex varchar2 (2) 4)
5 /
Delete from test a where a.rowid! = (Select max (rowid) from test b where a.name = b.nameand a.sex = b.sex);