Mysql select count values from a single column

Question

A have a column named key - 1,1,2,2,2,2,3 Now i do it with 3 querys:

SELECT count(key) as k FROM `test` WHERE key=1
SELECT count(key) as k FROM `test` WHERE key=2
SELECT count(key) as k FROM `test` WHERE key=3

How to count in one query how many 1,2,3?

Does this answer your question? Count the occurrences of DISTINCT values — mickmackusa
– mickmackusa ♦, Commented Apr 20, 2021 at 9:32

fabien · Accepted Answer · 2013-08-25 08:03:33Z

10

Use group by:

SELECT `key`, COUNT(*) FROM `test` GROUP BY `key`;

answered Aug 25, 2013 at 8:03

fabien

1,5591 gold badge16 silver badges28 bronze badges

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

Comments

Aman Varshney · Accepted Answer · 2013-08-25 07:56:06Z

1

you can do like this

select count(key) as K FROM test where key in (1,2,3)

answered Aug 25, 2013 at 7:56

Aman Varshney

8401 gold badge9 silver badges26 bronze badges

1 Comment

Aman Varshney Over a year ago

otherwise you can use groupby

Boice · Accepted Answer · 2017-05-26 13:52:20Z

1

This is another option:

SELECT sum(key=1) as k1, sum(key=2) as k2,sum(key=3) as k3 FROM `test`

you could also add a group by column if the values of key were part of some other group.

answered May 26, 2017 at 13:52

Boice

1551 silver badge7 bronze badges

Comments

commit · Accepted Answer · 2013-08-25 08:07:52Z

0

Try this

SELECT  COUNT(Key) as K
        FROM 
        test 
        GROUP BY Key

answered Aug 25, 2013 at 8:07

commit

4,82715 gold badges45 silver badges71 bronze badges

Collectives™ on Stack Overflow

Mysql select count values from a single column

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related