USE Database
SELECT ColumnName
FROM Table
Group BY ColumnName
Having count(*) > 1