分组情况下不同状态计数
SELECT
sum(case when task_status!=2 then 1 ELSE 0 end) as noNUm ,
sum(case when task_status=2 then 1 ELSE 0 end) as endNum
from quality_task WHERE task_type = #{taskType}
查询七天类,并且每一天计数
select
SUBSTRING(DATE_FORMAT(create_time,'%Y%-%m%-%d') ,6 ,9) as dayName,
count(*) as num
from 表名
where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <![CDATA[ <= ]]>
date(create_time) group by dayName
case when用法
SELECT
CASE WHEN task_type = 0 THEN '日常'
WHEN task_type = 1 THEN '循环'
WHEN task_type = 2 THEN '周期'
END as taskTypeName,
task_type,
COUNT(task_type) as num
FROM 表名 GROUP BY task_type