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 a constraint? : Sql dba

1115

Is oracel sql developer written in java?

1073

What is the difference between a procedure and a function?

1040

Which normal form is best?

909

what are different types of collation sensitivity? : Sql dba

1042

what is primary key? : Sql dba

972

Explain character-manipulation functions?

1085

What are the built in functions of sql?

997

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

1058

What is difference between db2 and sql?

956

How does join work in sql?

973

What is scalar and vector?

955

Is left join and outer join same?

1022

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1399

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2123