Search This Blog

Friday, September 7, 2012

Query for display the total no.of employees and year wise total no.of employees joined in to company



select count(*),count(decode(to_char(hiredate,'yyyy'),'1981',ename))"1981"
                ,count(decode(to_char(hiredate,'yyyy'),'1982',empno)) "1982"
                ,count(decode(to_char(hiredate,'yyyy'),'1983',empno)) "1983" from jagan;

No comments:

Post a Comment