Count records for every month in a year

Question

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 

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?

I tried:

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

Answer 1

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

Answer 2

This will give you the count per month for 2012;

SELECT MONTH(ARR_DATE) MONTH, COUNT(*) COUNT FROM table_emp WHERE YEAR(arr_date)=2012 GROUP BY MONTH(ARR_DATE); 

Demo here.