Skip to content

Instantly share code, notes, and snippets.

@aembleton

aembleton/Frequency of email address domains

Created March 22, 2013 14:00
Show Gist options
  • Save aembleton/5221468 to your computer and use it in GitHub Desktop.
Save aembleton/5221468 to your computer and use it in GitHub Desktop.
Download ZIP
Find the frequency of email address domains from your email table.
Raw
Frequency of email address domains
select substring_index(value, '@',-1) as email, count(*) as frequency FROM emailTable where name="EmailAddress" group by email order by frequency desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment