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
How do I get sql certification?
How to start the command-line sql*plus?
What is pl sql record in oracle?
What is sql integrity?
What does joining a thread mean?
What is the difference between a procedure and a function?
how is exception handling handled in mysql? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
What does rownum mean in sql?
What is difference between joins and union?
what are aggregate and scalar functions? : Sql dba
List the various privileges that a user can grant to another user?
Is sql a oracle?
What is %rowtype in pl sql?
What is left join in postgresql?