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

4 Answers
10174 Views
Fidelity, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1141

What is the importance of sqlcode and sqlerrm?

1359

Is sql between inclusive?

1142

Can we insert data into materialized view?

955

What is join view in sql?

949

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

963

What is a loop in sql?

992

What is the best partition size for windows 10?

1007

Can we perform dml on view?

1052

What is sp_helptext?

1071

What is the use of index in sql?

1023

what is self-join? : Sql dba

1171

How can you fetch first 5 characters of the string?

1021

Which join is default?

961

How to use boolean type in select statement?

1085