select companyname ,
sum(case when extract(quarter from writetime) =‘1’ then 1 else 0 end) as quarterone,
sum(case when extract(quarter from writetime) =‘2’ then 1 else 0 end) as quartertwo,
sum(case when extract(quarter from writetime) =‘3’ then 1 else 0 end) as quarterthree,
sum(case when extract(quarter from writetime) =‘4’ then 1 else 0 end) as quarterfour,
count(*) as totalnum from departurehighrisk group by companyname
SQL按照季度进行查询分组
最新推荐文章于 2024-07-30 04:02:29 发布
该博客分析了高风险离职部门在四个季度的数据,按公司名称分组展示了每个季度的员工离职情况。通过对extract(quarter from writetime)的条件求和,得出各季度的离职人数,总离职人数,揭示了不同公司在一年中离职风险的季节性变化趋势。
摘要由CSDN通过智能技术生成