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

how to include numeric values in sql statements? : Sql dba

561

What is a sql*loader control file?

620

What is primary key and unique key?

547

What is raid? How does it help storage of databases?

603

What is blind sql injection?

578

How can you fetch first 5 characters of the string?

554

what are the nonstandard string types? : Sql dba

608

What is a join?

628

Can we call dml statement in function?

542

What is trigger types in sql?

535

In pl/sql, what is bulk binding, and when/how would it help performance?

533

What is normalisation and its types?

550

Why do we need cursors in pl sql?

520

Write the alter statement to enable all the triggers on the t.students table.

673

What is java sql package?

536