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;