oracle统计函数统计各个年份入职的人数

最新推荐文章于 2022-10-10 09:39:09 发布

iteye_18341

最新推荐文章于 2022-10-10 09:39:09 发布

阅读量3.4k

点赞数 1

分类专栏： oracle统计函数统计各个年份入职的人数文章标签：数据库

本文链接：https://blog.csdn.net/iteye_18341/article/details/82579516

版权

oracle统计函数统计各个年份入职的人数专栏收录该内容

1 篇文章 1 订阅

订阅专栏

--统计各个部门各个年份的入职人数 --还有一个人不属于任何部门
select
e.department_id,
d.department_name,
count(*) total,
sum(decode(to_char(hire_date,'yyyy'),'2001',1,0)) "2001",
sum(decode(to_char(hire_date,'yyyy'),'2002',1,0)) "2002",
sum(decode(to_char(hire_date,'yyyy'),'2003',1,0)) "2003",
sum(decode(to_char(hire_date,'yyyy'),'2004',1,0)) "2004",
sum(decode(to_char(hire_date,'yyyy'),'2005',1,0)) "2005",
sum(decode(to_char(hire_date,'yyyy'),'2006',1,0)) "2006",
sum(decode(to_char(hire_date,'yyyy'),'2007',1,0)) "2007",
sum(decode(to_char(hire_date,'yyyy'),'2008',1,0)) "2008"
from emp e,departments d where e.department_id=d.department_id(+) group by e. department_id,d.department_name
-- where e.department_id=20