mysql case when查询

select mydate,
CASE
    when `status` = 0 then count(*)
		else '0'
END success_num,
CASE
    when `status` >=0 then count(*)
		else '0'
END all_num
from `data`  group by mydate

结果如下：

一种更简单的写法：

 

select mydate ,sum(`status` = 0) as success_num ,count(*) as all_num from `data` GROUP BY mydate