Just a short SQL script which will allow you to find the mutiple rows with the same values in the same table. I am not going to explain what the query does since its a very straight forward query
PLAIN TEXT
SQL:

SELECT [column_name]

FROM [tablename]

GROUP BY [column_name]

HAVING count(*)> 1

--  OR

SELECT * FROM [TableName] WHERE [ColumnName] IN (

SELECT [ColumnName] [...]