SELECT column, COUNT(column)
FROM table
GROUP BY column
HAVING ( COUNT(column) > 1 );