closing headcount

[Anonymous]

Hi All,

I need closing headcount by month wise from 2014 to till date. Pls help me.

EX:

EMP_ID	NAME	DOJ	MONTH
25	A	01-11-1997	01-Jan-16
25	A	01-11-1997	01-Jan-16
31	B	15-01-1999	01-Jan-16
35	C	13-01-1995	01-Jan-16
45	A	06-11-2001	01-Jan-16
21685	A	04-01-2016	01-Jan-16
21691	B	04-01-2016	01-Jan-16
21694	C	04-01-2016	01-Jan-16
21696	A	04-01-2016	01-Jan-16
21699	B	11-01-2016	01-Jan-16
25	A	01-11-1997	01-Feb-16
25	A	01-11-1997	01-Feb-16
31	B	15-01-1999	01-Feb-16
35	C	13-01-1995	01-Feb-16
45	A	06-11-2001	01-Feb-16
21856	A	01-02-2016	01-Feb-16
21859	B	01-02-2016	01-Feb-16
21862	C	01-02-2016	01-Feb-16
21865	A	01-02-2016	01-Feb-16
21867	B	01-02-2016	01-Feb-16
21868	C	01-02-2016	01-Feb-16
21870	A	01-02-2016	01-Feb-16

Thanks,

Krishna.