CODE EXAMPLE FOR SQL

sql select in where clause for when more than one records exists

SELECT *
FROM tableName
WHERE columnName IN (SELECT *
                        FROM (SELECT columnName
                              FROM tableName
                              GROUP BY columnName
                              HAVING COUNT(columnName) > 1)
                        AS someLabel);