How to get multiple count in single query

Question

I have a table of Student which has fields

ID  |   Name        |   Class   |  
---------------------------------
1   |   One         |   Class1  |  
2   |   Two         |   Class2  |  
3   |   Three       |   Class1  |

I want to get the count of students for each class in a single Query. Like.

Class   |   Count   |
---------------------
Class1  |   2       |
Class2  |   1       |

It would be great if you could show some kind of effort on your part. — Debosmit Ray
– Debosmit Ray, Commented Mar 20, 2016 at 6:27
This is basic group by statement which you can construct on your own if you know the basics, you can learn more about SQL Group by on W3Schools - Group By — Techie
– Techie, Commented Mar 20, 2016 at 6:37

Uttam Kumar Roy · Accepted Answer · 2016-03-20 06:22:00Z

4

You can try this

SELECT
 Class,
 COUNT(*) AS Count
FROM
  Student 
GROUP BY
  Class

answered Mar 20, 2016 at 6:22

Uttam Kumar Roy

2,0584 gold badges24 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

NCA Over a year ago

What to do if a condition also to be added ?

Uttam Kumar Roy Over a year ago

WHERE your_condition GROUP BY Class;

Collectives™ on Stack Overflow

How to get multiple count in single query

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related