对符合条件的数据统计个数

  • Z时代
  • 2024-01-10
  • 分类：综合

database

select   max(m.check_score) as jcmax , min(m.check_score)  as jcmin ,avg(m.check_score) as jcavg ,count(*) as jccount ,sum( case  when m.check_score >=80 then 1 else 0 end) as jcdbs
		, max(m.self_score) as zcmax , min(m.self_score)  as zcmin ,avg(m.self_score) as zcavg ,count(*) as zccount ,sum( case  when m.self_score >=80 then 1 else 0 end) as zcdbs
		from tb_report_anfang_result m,
		(select max(create_time) as create_time , dept_id from tb_report_anfang_result r where r.dept_id in
		<foreach collection="depts" item="item" index="index"
				 separator="," open="(" close=")">
			#{item.deptId}
		</foreach>
		and   to_days(r.create_time) <![CDATA[ <= ]]> to_days(#{datetime}) group by r.dept_id ) as temp
		where m.create_time = temp.create_time and m.dept_id = temp.dept_id

 

select count(*) as rys ,
sum( case  when binglileixing  = "XX人员"  then 1 else 0 end) as mjry ,  
sum( case  when isMeetCondition  = 1  then 1 else 0 end) as glqwmry  ,
sum( case  when photourl  is not null   then 1 else 0 end) as xczm
 from fgtb_tianbao  where lid in (76,77) 

 

 

 

以上是 对符合条件的数据统计个数 的全部内容， 来源链接： utcz.com/z/532642.html

回到顶部