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 can we know the number of days between two given dates using mysql? : Sql dba
What is pragma in pl sql?
What are the limitations of sql express?
What is a table in a database?
Why is there a need for sqlcode and sqlerrm variables?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Is mariadb nosql?
what is sub-query? : Transact sql
how many triggers are allowed in mysql table? : Sql dba
What is a stored procedure in sql with example?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Is like operator in sql case sensitive?
what is self-join? : Sql dba
what is bcp? When does it used? : Sql dba
what are the different type of normalization? : Sql dba