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

Delete duplicate rows using DELETE JOIN statement

DELETE t1
FROM
    user_account t1
    INNER JOIN user_account t2
WHERE
    t1.id < t2.id
    AND t1.email = t2.email;