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
Is sqlite free?
How do I save a stored procedure?
What is the command used to fetch first 5 characters of the string?
What is a join?
What does varchar include?
What is pl sql block in dbms?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is triggering circuit?
What is data manipulation language?
What is varchar example?
What is a natural join sql?
how would you enter characters as hex numbers? : Sql dba
How is indexing done in search engines?
What is rollback?
how do you login to mysql using unix shell? : Sql dba