Oracle analysis function for deleting duplicate data

There are 16.77 million data records in a table, and 5.71 million data records are different. When not all fields have the same content, for example, 100 people with the same name and surname have different salaries, and other fields have the same content.

You cannot use the rowid method.

The statement is as follows:
Query data:
Select * from table 1 Where rowid! = (Select max (rowid)
From table1 B where a. name1 = B. name1 and a. name2 = B. name2 ......)
Delete data:
Delete from table 1 Where rowid! = (Select max (rowid)
From table1 B where a. name1 = B. name1 and a. name2 = B. name2 ......)

Use

Delete from emp2
2 WHERE ROWID IN
3 (SELECT ROWID
4 FROM (Select rowid,
5 ROW_NUMBER () OVER (partition by empno order by empno) rn
6 FROM emp2)
7 WHERE rn> 1 );

Delete a row based on the employee ID and leave only one row