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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sqlite free?

538


How do I save a stored procedure?

526


What is the command used to fetch first 5 characters of the string?

886


What is a join?

628


What does varchar include?

519






What is pl sql block in dbms?

528


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

556


What is triggering circuit?

597


What is data manipulation language?

702


What is varchar example?

576


What is a natural join sql?

513


how would you enter characters as hex numbers? : Sql dba

516


How is indexing done in search engines?

531


What is rollback?

584


how do you login to mysql using unix shell? : Sql dba

568