Отыскать повторяющиеся в поле email таблице privateEmployee?

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