MySql Select query

Question

I have a table like this

id status
1  Pass
2  Fail
3  Pass

How can I count total rows and rows where status is "Fail" with their id(s) by group_concat in one select query. I am trying to get output like this

total group_concat(id)
3     1,2,3
1     2

Any advice?

Denis de Bernardy · Accepted Answer · 2011-05-30 12:29:51Z

1

you'll need to union two separate queries:

select status,
       count(*) as num,
       group_concat(id) as ids
from tests as status_stats
union all
select null as status,
       count(*) as num,
       group_concat(id) as ids
from tests as total_stats

answered May 30, 2011 at 12:29

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

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

Collectives™ on Stack Overflow

MySql Select query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related