Used follwing syntax

Syntex:
Select columnName From Table_name
Group By columnName
Having count (*) > 1