I
I
inververs2015-11-16 13:50:10
MySQL
inververs, 2015-11-16 13:50:10

Is it possible to calculate the COUNT for each element_id grouped by another field?

Tell me about this question:
Here is a piece of the table: 007adcd5d80847eeb65bc2cc000aaefa.png
I want to count the number of elements for different sim_id
And get the following as a result:
sim_id|number of elements 42|number of elements 43
20|5|3
21|1|0
Is it possible to do this in one query ?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question