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.
