select email, count(*) from emp group by email

Question

I have a table with columns name and email. The table has 10 records. I want to send an email for all the records. What is the query for that?

Your question title will achieve the same functional result as the DISTINCT statement. But the latter spares you from having to use aggregates unnecessarily. http://stackoverflow.com/questions/164319/is-there-any-difference-between-group-by-and-distinct — ne1410s, Dec 06 '14 at 07:38

score 0 · Answer 1 · answered Dec 06 '14 at 07:31

0

Try this:

SELECT DISTINCT email FROM emp

answered Dec 06 '14 at 07:31

Saharsh Shah

score 0 · Answer 2 · answered Dec 06 '14 at 07:35

0

Try this:

SELECT CONCAT(DISTINCT email, ';')
FROM emp

Will output like: abc@gmail.com;pqr@yahoo.com... in one column

answered Dec 06 '14 at 07:35

SMA

2 Answers2