Oracle deletes duplicate records, leaving only one

Table

CREATE TABLE Aa_test
(
AAAA NVARCHAR2 (20),
BBBB number,
CCCC NVARCHAR2 (20)
)

Delete in two steps: first save to meet the requirements of the

Delete from Aa_test t where (T.AAAA,T.BBBB) isn't in (

Select T1.aaaa,max (T1.BBBB) from Aa_test T1 GROUP by T1.AAAA

);

The second step is to delete the duplicate records on the basis of the first step.

Delete from Aa_test t where rowID isn't in (
Select min (rowid) from aa_test t1 where t.aaaa = t1.aaaa and t.bbbb = t1.bbbb
);

Oracle deletes duplicate records, leaving only one