How to select the rows that have the same values in some columns?

[thg]

data in table 'TEST':

column01, column02, column03
AAA, AAA,AAA
ABC,ABC,ABC
ACB, ACB, ACB
BAC, AAA, BAC



You can see that values of the column 'column02' are the same for the first row and the fourth row. They are both 'AAA'.


I would like to find out which value is duplicated in a certain column by executing a SQL select query. is this possible?

Thanks.