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

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

Question Posted / radha

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

Answers were Sorted based on User's Feedback

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

Answer / kiran

select count(*) "NoFDevelopers",to_char(hiredate,'Mon') from emp group by to_char(hiredate,'Mon');

Is This Answer Correct ?

1 Yes

0 No

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

Answer / arrry.net

It's simple
No need to use Cursor for that

select Month(Joindate)as MONTH,count(*) as empCount from dbo.tblEmployee
Group by Month(Joindate)

Is This Answer Correct ?

1 Yes

1 No

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

Answer / 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

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

Answer / narenkumar reddy

create or replace procedure
procdure_name
cursor c1 is select count(*),month from table
is
begin
for i in c1
loop
dbms_output.put_line(i.count(*)||i.month)
end loop;
end;

Is This Answer Correct ?

2 Yes

6 No

Post New Answer