Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT emailaddress, COUNT(*) AS frequency
- FROM tablename
- GROUP BY emailaddress ;
- SELECT frequency, COUNT(*) AS emailadresses
- FROM
- ( SELECT COUNT(*) AS frequency -- we don't need email any more
- FROM tablename
- GROUP BY emailaddress
- ) AS x
- GROUP BY frequency ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement