How do I get domain name and number of emails in mysql

Question

I have table looks like following

Email                Domain
------               ------
test@gmail.com       gmail.com
test@gmail.com       gmail.com
test@gmail.com       gmail.com
test@yahoo.com       yahoo.com
test@yahoo.com       yahoo.com
test@outlook.com     outlook.com

How do I write a sql query to get the following result

Expected result
---------------
gmail.com    3
yahoo.com    2
outlook.com  1

Any answer will be appreciated. Thanks.

`select domain,count(*) as result from table group by domain` — Abhik Chakraborty, Mar 12 '15 at 06:29
possible duplicate of [MySQL Query with count and group by](http://stackoverflow.com/questions/14344810/mysql-query-with-count-and-group-by) — JamesENL, Mar 12 '15 at 06:37

score 1 · Accepted Answer · answered Mar 12 '15 at 06:30

1

This is the simplest use of GROUP BY

   SELECT domain, COUNT(*)
     FROM mytable
 GROUP BY domain

answered Mar 12 '15 at 06:30

Jordi Llull

810
6
17

1

@user3458584 If you find any answer helpful then up vote that or Accept the answer – HybrisHelp Mar 12 '15 at 06:33

score 0 · Answer 2 · answered Mar 12 '15 at 06:32

0

Use Group by and Count(*) function, Try this

select Domain,count(*) from Table_Name group by Domain

answered Mar 12 '15 at 06:32

Karthikeyan

381
8
19

How do I get domain name and number of emails in mysql

2 Answers2