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 is memory optimized?

547

How do you run a query?

581

How do I make sql search faster?

550

What does count (*) do in sql?

516

How do I edit a trigger in sql developer?

533

How do I get sql certification?

521

What are predefined functions in sql?

525

what is a database transaction? : Sql dba

577

Can we write ddl statements in functions?

559

What are properties of the transaction?

552

Explain commit, rollback and savepoint.

598

How global cursor can be declare with dynamic trigger ?

1742

how to use myisamchk to check or repair myisam tables? : Sql dba

503

What is assignment operator in pl sql?

559

What are different types of sql commands?

502