write a query that returns one row for each department and the number of employees in that department.
Given two tables EMPLOYEE and DEPARTMENT, where there can be multiple employees per department.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Programming Languages AllOther Interview Questions

To sorting array of 10 elements which sorting is best a)selection b)bubble c)tree sort

2 Answers   HP, Hughes,


what is the diffrence between occur 0 and occur 10 in ABAP.

0 Answers  


what is the last ant version you worked?how to get it

0 Answers  


what is difference between IF-ELSE-ENDIF and IIF.

2 Answers  


what is the work of 1tier,2tier,&ntier? Plz Explain it!

0 Answers  






4. What is the need of START 0? Instead if can we use any other numeric? If we use what will happen?

0 Answers   TCS,


how we can know the funcions available in a class recording java?

0 Answers  


hi friends i am ravi here , i have one problem at starting at the interview that is i have my 3+ it(java) years experiance profile so if i attend the interview interviewer ased me tel me about your profile so i not able to explain because i dont knw where to start and where to end and i dont know what i should tel and what i shouldnot tel .....so can any body please clear m doubts clearly.............please help me friends,i am awaiting for friends reply please.............

2 Answers   TCS,


what are all the validation we need to perform in data stage?

0 Answers  


what is fisrt female program

1 Answers  


what is woransient key word? how it is used in java

0 Answers   Convergys,


how to run servlets in eclipse 3.3.2....if we choose file->new->servlet then after that it is showing javax.servlet.* ...cannot be resolved.......to avoid this error any external jar file is to be added? please help me regarding this issue........thank u

2 Answers   IBM,


Categories