B
B
BestJS2017-08-03 13:39:01
PostgreSQL
BestJS, 2017-08-03 13:39:01

How to count how many of each of the values ​​in the table?

The overgrowth which on a column will count how many of each of values ​​in the table is necessary.
For example, here is a table:
1cd66986a55b4002ba982def325bcaf2.png
You need to group by the radio column and count how many of each value are in the table.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Maxim Fedorov, 2017-08-03
@BestJS

SELECT count(*), radio FROM likes GROUP BY radio

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question