Looking for query that displays Tot. no. of employes month wise

[sxp8808]

Hi guys pleas eanswer this question for me.

I am looking for query that displays total number of employess and the total number of employees month wise.

I wrote the following query for the total number of employeed in the month of dec.

SQL> select count(*) Total, count(decode(to_char(hiredate,'MONTH'),'DECEMBER',empno)) DEC from emp;

TOTAL DEC
---------- ----------

14 0
even though there are number fo employess in the month of dec it is giving me ')' in the output.

Please help me.

[bhaski]

give some sample data

[debasisdas]

Can you post your table structure for my reference ,please.

[jamesravid]

hay use either of these queries,

select count(*) Total, sum(decode(to_char(hiredate,'MONTH'),'DECEMBER',1,0)) DEC from emp;

select count(*) Total, count(decode(to_char(hiredate,'MONTH'),'DECEMBER',1,null)) DEC from emp;