Check if there are the same values for given column

Note that if you column a is of type VARCHAR and you're using MySQL, by default you'll get the same results for 'value', 'VALue', etc.

 SELECT email, COUNT(*) a FROM sometable GROUP BY a HAVING a > 1;