Find duplicated values on a table

With the next t-SQL statement you can find duplicate values in any table, just change the fields into the columns you want to search and change the table into the name of the table you need to search.

SELECT    
    FieldName
  , FieldName2
  , COUNT(*)
FROM
    SomeTableName
GROUP BY
    FieldName
  , FieldName2
HAVING 
    COUNT(*) > 1