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

[gsprince]

You culd do something like,

select A.* from myTable A, myTable B
where A.col1 = B.col1 or A.col2 = B.col2 or A.col3 = B.col3

Note: I haven't tested how good it performs