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

Question

[BabageldiCherkez]

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

Comments

[Akina]

GROUP BY, HAVING, COUNT()

[Yurock759]

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