计算一年中每个月的记录 [英] Count records for every month in a year

问题描述

我有一个总共没有 1000 条记录的表.它具有以下结构:

I have a table with total no of 1000 records in it.It has the following structure:

EMP_ID EMP_NAME PHONE_NO   ARR_DATE
1        A        545454 2012/03/12

我想计算 2012 年每个月的记录数

I want to calculate no of records for every month in year-2012

有什么办法可以一次性解决我的问题?

Is there any way that should solve my issue in a single shot?

我试过了:

select count(*) 
from table_emp 
where year(ARR_DATE) = '2012' and month(ARR_DATE) = '01'

推荐答案

SELECT    COUNT(*) 
FROM      table_emp 
WHERE     YEAR(ARR_DATE) = '2012' 
GROUP BY  MONTH(ARR_DATE)

这篇关于计算一年中每个月的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！