select to_char(hiredate, 'MON-RRRR'),count(1) from emp group by

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

Question Posted / vishal narkhede

Answer Posted / vishal narkhede

select to_char(hiredate, 'MON-RRRR'),count(1) from emp
group by to_char(hiredate, 'MON-RRRR')

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you understand by pl/sql records?

721

What is loop in pl sql?

763

Can a commit statement be executed as part of a trigger?

799

How does index help in query performance?

762

How many types of functions are there in sql?

666

Does sql*plus have a pl/sql engine?

753

What is difference between joins and union?

747

Can I call a procedure inside a function?

738

When sql appeared?

815

explain advantages of myisam over innodb? : Sql dba

802

Can instead of triggers be used to fire once for each statement on a view?

712

Define SQL and state the differences between SQL and other conventional programming Languages?

871

When you have to use a default "rollback to" savepoint of plvlog?

912

What is the most common sql injection tool?

738

How can the performance of a trigger be improved?

774