mysql 状态查询

select

COUNT(case when info.State = '0' then State end ) as daichuliCount,

COUNT(case when info.State = '1' then State end ) as yichuliCount,

COUNT(case when info.State IN('0','1') then State end) as allCount

from cloud_crmandsupportorder as info

where 1=1

and DATEDIFF(info.CreateDate,NOW())=-1

and info.UserId=''

;

select sClass 班级,count(*) 班级学生总人数,

sum(case when sGender=0 then 1 else 0 end) 该班级女生人数,

sum(case when sGender=0 then 1 else 0 end)*1.0/count(*) 该班级女生所占比例,

sum(case when sGender=1 then 1 else 0 end) 该班级男生人数,

sum(case when sGender=1 then 1 else 0 end)*1.0 /count(*) 该班级男生所占比例

from student GROUP BY sClass ORDER BY sClass asc

巴特西