mysql 统计函数中加判断语句
COUNT(if(TaskExecState="已完成" AND TaskFinishTime>BACK,TRUE,NULL))as FinishInTime,
COUNT(if(TaskExecState="已完成" AND TaskFinishTime<BACK,TRUE,NULL))as FinishOutTime,
COUNT(if(TaskExecState="未完成" AND TaskFinishTime<now(),TRUE,NULL))as UnfinishOutTime,
COUNT(if(TaskExecState="未完成" AND TaskFinishTime>now() AND DATEDIFF(TaskFinishTime,now())<7,TRUE,NULL))as CloseFinishTime,
COUNT(if(TaskExecState="未完成" AND TaskFinishTime>now() AND DATEDIFF(TaskFinishTime,now())>7,TRUE,NULL))as Ongoing,
COUNT(*)as total,
COUNT(if(TaskExecState="已完成" AND TaskFinishTime<BACK,TRUE,NULL))as FinishOutTime,
COUNT(if(TaskExecState="未完成" AND TaskFinishTime<now(),TRUE,NULL))as UnfinishOutTime,
COUNT(if(TaskExecState="未完成" AND TaskFinishTime>now() AND DATEDIFF(TaskFinishTime,now())<7,TRUE,NULL))as CloseFinishTime,
COUNT(if(TaskExecState="未完成" AND TaskFinishTime>now() AND DATEDIFF(TaskFinishTime,now())>7,TRUE,NULL))as Ongoing,
COUNT(*)as total,
COUNT(if(TaskExecState="已完成" AND TaskFinishTime>BACK,TRUE,NULL))/COUNT(*) as percent
IF() 函数就是一个简单的判断器，它会判断第一个参数是否成立，如果是 True，就会返回第二个表达式的值，如果是 False，会返回第三个表达式的值；
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
