Create a query to display the total number of employees, of that total, the number of employees hired in 1995, 1996, 1997, 1998. Create appropriate column heading from the employees table.

Prem_p

 Profile Answers by Prem_p Questions by Prem_p

• Apr 28th, 2011

SELECT count(e.empno) Emp_Count,to_char(e.hiredate,'YYYY') hired_On   from empoyee ewhere to_char(e.hiredate,'YYYY') in (1995, 1996, 1997, 1998)group by rollup(to_char(e.hiredate,'YYYY')) order by 2

mlodugu

 Profile Answers by mlodugu Questions by mlodugu

• Apr 10th, 2011

How about this?SELECT SUM(sal) Total_sal, extract(year from hiredate) YrFROM scott.emp GROUP BY Rollup(extract(year from hiredate))

Answer Question  Select Best Answer