mysql - MySQL查询中的多个嵌套if语句

Question

我正在尝试下面的查询，MySQL 给了我这个错误:组函数的使用无效

 SELECT C.`some_name`,
        SUM(IF(A.`med_type` = 1, SUM(A.`med_qty`), 0)) AS total,
        SUM(IF(A.`is_rejected` = 4, 1 , 0)) AS approved, 
        SUM(IF(A.`is_rejected` = 2, 1 , 0)) AS qeue, 
        SUM(IF(A.`is_rejected` = 3, 1 , 0)) AS rejected, 
        SUM(IF(A.`is_rejected` = 1, 1 , 0)) AS fresh
   FROM `ne_media` A
  INNER JOIN `ne_member` B ON A.`mem_id`  = B.`mem_id`
  INNER JOIN `ne_some`   C ON B.`some_id` = C.`some_id`
  GROUP BY C.`some_id`;

如果med_type = 1，我想对med_qty求和。

我该怎么做？

Answer 1

用途:

    SUM(CASE WHEN (A.`med_type` = 1) THEN A.`med_qty` ELSE 0 END)) AS total,

或者:

    SUM(IF(A.`med_type` = 1, A.`med_qty`, 0)) AS total,

您无法像在原始版本中那样对聚合进行聚合。