Combine multiple MySql queries into a single query

Question

i have table name users.

id   name date       cdate           c  a   b
1     rz  42121221  42121221         0  1   0
2     an  12122111  42121221         0  0   1
3     cb  22121221  42121221         1  1   1   
4     ss  3321221   42121221         1  0   0

i have two select the values between two dates,and then i have to find the count using this statement.

 SELECT COALESCE(SUM(IF(c=1 AND a=0 AND b=1  ,  1, 0)),0) AS ACTIVE WHERE DATE BETWEEN 'DATE 1' AND 'DATE 2',COALESCE(SUM(IF(c=0 AND a=0 AND b=1  ,  1, 0)),0) AS INC WHERE cdate BETWEEN 'DATE 1' AND 'DATE 2' FROM users

this query is not working

Why do you want to do it in a single statement? What benefit will this give you? — Mark Byers
– Mark Byers, Commented Jun 8, 2012 at 11:30
first i want to get the values between two dates then i have to use this query SELECT COALESCE(SUM(IF(c=1 AND a=0 AND b=1 , 1, 0)),0) AS ACTIVE — coolboy
– coolboy, Commented Jun 8, 2012 at 11:33

hkutluay · Accepted Answer · 2012-06-08 11:35:50Z

1

Use like

select COALESCE(SUM(IF(c=1 AND a=0 AND b=1  ,  1, 0)),0) AS ACTIVE from users where date between 'date1' and date '2'

answered Jun 8, 2012 at 11:35

hkutluay

6,9742 gold badges37 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Combine multiple MySql queries into a single 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