Count records for every month in a year April 6, 2023 by Tarik SELECT COUNT(*) FROM table_emp WHERE YEAR(ARR_DATE) = '2012' GROUP BY MONTH(ARR_DATE)