select count(*) "NoFDevelopers",to

wa procedure to return the month and the no'f developers
joined in each month.

Question Posted / kiran

Answer Posted / kiran

select count(*) "NoFDevelopers",to_char(hiredate,'Mon') from emp group by to_char(hiredate,'Mon');

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is table in a database?

1003

what is 'trigger' in sql? : Sql dba

1011

Why we use stored procedure instead of query?

950

What is left inner join in sql?

985

Is sql workbench free?

929

How bulk collect improves performance?

947

What is the difference between sql and t sql?

964

What are the different sql languages?

985

Determine if oracle date is on a weekend?

981

Can one improve the performance of sql*loader? : aql loader

981

What does an inner join do?

1090

What is cursor and why it is required?

1105

Explain the difference between triggers and constraints?

919

Describe sql comments?

959

How do you break a loop in pl sql?

985