SELECT columnA, COUNT(columnA) AS NumOccurrences
FROM tableName
GROUP BY columnA
HAVING ( COUNT(columnA) > 1 );