select extract(month from hiredate) 入职月份,count(*) 人数 from emp
where extract(year from hiredate)='1981' group by extract(month from hiredate) order by 入职月份;

结果:

 

posted on 2016-09-23 15:49  风吹羽  阅读(1282)  评论(0编辑  收藏  举报