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

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:
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 ?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

T

twittoponchik2022-01-07 12:30:00

Can I withdraw money from AdSense to my IP if the application is posted on Google Play on behalf of an LLC? 5Reply

P

PEKTOP2014-05-15 16:47:54

Why did git pull start saving files as root? 7Reply

7

7a-6662022-02-05 17:26:31

How to get to the runserver that was launched inside the container from the browser? 2Reply

W

wangler2016-01-26 01:34:09

Designing a database application. How to link two bases? 1Reply

D

digdream2016-01-26 11:02:27

How to make output from one mysql table into two columns? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question