How to get the duplicate records of one table?

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.