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

What is primary key and foreign key?

970

Mention what are different methods to trace the pl/sql code?

1222

What is difference between sql function and stored procedure?

1017

Explain correlated query work?

1060

What are instead of triggers?

1053

How do I view a sql database?

1023

how to load data files into tables with 'mysqlimport'? : Sql dba

1103

What is query execution plan in sql?

1195

What is sql keyword?

1011

Why do we need cursor in pl sql?

1142

What are the two virtual tables available at the time of database trigger execution?

1234

What is pl sql variable?

1001

How do you determine the current isolation level? : Transact sql

1166

What is sql table?

978

How do I clear the screen in sql plus?

1051