Delete duplicate records

SELECT *
FROM `wp_wpmlsubscribers`
WHERE `email` IN (
    SELECT `email`
    FROM `wp_wpmlsubscribers`
    GROUP BY `email`
    HAVING count(`email`) > 1
    )
ORDER BY `email`