Find out in which year maximum number of employee has been recruited ?

Find out in which year maximum number of employee has been recruited ?

Retrieve data from emp table

The Query

select to_char(hiredate,'yyyy'),count(*) 
from emp 
group by to_char(hiredate,'yyyy') 
having count(*)>=(select max(count(*)) from emp group by to_char(hiredate,'yyyy'))
;

Leave a Reply