Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,


what is a database? : Sql dba

0 Answers  


What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,


What is a natural join sql?

0 Answers  


What is query syntax?

0 Answers  


Explain what is a database?

0 Answers  


What is the difference between microsoft sql and mysql?

0 Answers  


what is difference between pass by value and eference by value in oracle plsql

1 Answers  


How many types of normalization are there?

0 Answers  


How many row comparison operators are used while working with a subquery?

0 Answers  


How do I add a primary key to a table?

0 Answers  


What are the two parts of design view?

0 Answers  


Categories