Hi All,
I have written the below code to get number of employees joined on each month irrespective of the year from the employee table. But i couldnt get the result. Kindly help me as where i am wrong in my coding,
select to_char(hiredate,'mon') as join, count(empno) as Number
from emp
group by to_char(hiredate,'mon')
having count(empno)>1;