SELECT emailaddress, COUNT(*) AS count

FROM [w170049_newsletters_journey_ALL]

GROUP BY emailaddress

HAVING COUNT(*) > 1

downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter