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;
Read next
From @symfonydev
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;