Answer the question
In order to leave comments, you need to log in
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:
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 questionAsk a Question
731 491 924 answers to any question