将多个MySql查询合并到一个查询中

问题描述：

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

我有表名用户。 p>

  id name date cdate cab 
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 
  code>  pre> 
 
 我有两个选择两个日期之间的值，然后我必须使用此语句查找计数。 p> 
 
 
  SELECT COALESCE（SUM（IF（c = 1 AND a = 0 AND b = 1,1,0）），0）在'日期1'和'日期2'之间的日期，COALESCE（SUM（  IF（c = 0 AND a = 0 AND b = 1,1,0）），0）AS INC在用户之间进行“日期1”和“日期2”之间的转换
  code>  pre> 
  
 此查询无法正常工作 p> 
  div>

答

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'

将多个MySql查询合并到一个查询中

相关推荐