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

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

More SQL PLSQL Interview Questions

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

0 Answers  


What is sql lookup?

0 Answers  


How many types of cursors are available in pl/sql?

0 Answers  


What is the basic structure of an sql?

0 Answers  


What is right join sql?

0 Answers  






How can I delete duplicate rows?

0 Answers  


What do you understand by pl/sql cursors?

0 Answers  


What is time based sql injection?

0 Answers  


Can pl sql procedure have a return statement?

0 Answers  


What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,


How to change sql*plus system settings?

0 Answers  


How many commands are there in sql?

0 Answers  


Categories