How to find duplicates in two SQL columns?

Question

SQL

Example,
Column1 Column2
John John
Bill Bill
Nick Nick

In general, you need to output in this form.

Answer 1

select Столбец1 , Столбец2  from Таблица where Столбец1 = Столбец2