I have data like this How can I get output like this: (with MySQL query) Answer Try this:

MySQL count multiple GroupBy

I have data like this

id  otherid name    
1   123     banana
2   123     banana
3   123     banana
4   456     grape
5   456     grape
6   789     orange
7   111     banana

​x
 
id  otherid name    1   123     banana2   123     banana3   123     banana4   456     grape5   456     grape6   789     orange7   111     banana​

How can I get output like this: (with MySQL query)

name    count
banana  2
grape   1
orange  1

 
name    countbanana  2grape   1orange  1​

Answer

Try this:

SELECT 
  f.`name`,
  COUNT(DISTINCT (f.`otherid`)) 
FROM
  `fruits` f 
GROUP BY f.`name`

 
SELECT   f.`name`,  COUNT(DISTINCT (f.`otherid`)) FROM  `fruits` f GROUP BY f.`name` ​

Advertisement

Answer