One BI consultant's dream...
Refer to the SQ as below:
SELECT * from A_TEST where rowid not in ( select MIN(t1.rowid) from A_TEST t1 group by t1.A,t1.B,t1.C);
it is really a good way using ROWID for row identification.