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 embedded sql in db2?

962

Can we rollback after truncate?

982

What is sql query optimization?

1023

How can I get the number of records affected by a stored procedure?

1003

What is sqlerrd?

921

How to set up sql*plus output format in oracle?

977

What is the purpose of a sql?

915

Is sql an operating system?

963

What is the difference between row level and statement level trigger?

960

How do you go back in sql?

942

What are the sql commands?

1099

Is a foreign key always unique?

885

What is restrict in sql?

1035

What are the different types of constraints?

1075

What is the main reason behind using an index?

966