MySQL Query for selecting multiple count Column

Question

I have a table like this-

I want to run a query so that I can have a output like it-

I don't have a clear idea how to do it. So, what I have done is-

SELECT
        Count(* where status="Active") as count_active
        Count(* where status="Inctive") as count_inactive
        Count(* where status="Biase") as count_biase
    FROM `subscribers`

And getting error, can anyone please help?

Ullas · Accepted Answer · 2015-09-24 08:41:57Z

3

Can achieve this with a Case expression.

Query

select 
count(case when status = 'Active' then 1 else null end) as Active_Count,
count(case when status = 'Inactive' then 1 else null end) as Inctive_Count,
count(case when status = 'Biase' then 1 else null end) as Biase_Count
from tbl_name;

SQL Fiddle

edited Sep 24, 2015 at 8:41

answered Sep 24, 2015 at 8:16

Ullas

11.6k5 gold badges36 silver badges52 bronze badges

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

Comments

jordi · Accepted Answer · 2015-09-24 08:40:09Z

0

This is the way to put it in a single register:

SELECT 
(SELECT count(id) FROM new_table where status = 'Active') as Active_Count,
(SELECT count(id) FROM new_table where status = 'Inactive') as Inctive_Count,
(SELECT count(id) FROM new_table where status = 'Biase') as Biase_Count;

answered Sep 24, 2015 at 8:40

jordi

1,1871 gold badge17 silver badges38 bronze badges

Collectives™ on Stack Overflow

MySQL Query for selecting multiple count Column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related