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

How to merge Action Form with Dyna Action Form in Struts.

0 Answers  


can u send some model papers how computer awareness questions are asked in goverment jobs(oriental insurance)to my mail id me.priyankapadma@rediff.com

0 Answers  


What is the effect of the OPTIONS statement ERRORS=1?

3 Answers   QSG, Quintiles, SAS,


how can we maintain the previous version scripts to new version.

0 Answers   DST Global Solutions,


What is procedural oriented language language..? give some examples of this language....?

0 Answers  






How Many versions are there in crystal reports

2 Answers   Wipro,


is it possible to desable particular parameter of the normal orcle report based on some condition ?????? if yes,wht is the function for desabling a parameter...

0 Answers  


Tips for blog integration by www.esteemwebsolutions.com. Can Any body suggest me to how to make wonderful questions on web integration..

0 Answers  


i am getting the error while compiling my cics program with including db2 dclgen member it is showing that ur dclgen member not including and all the host variables are undeclared

0 Answers   TCS,


Java is called as pure objerct oriented programming language, where as c++ is not completely object oriented.can any explain the detailed differenec between these two

4 Answers  


what are stubs related to foxpro?

0 Answers  


SAS question: I have 50 fils a1,a2,...,a50. the primary key is upc. then if i want to merge all 50 files, the code is as follows, data test; merge a1 ... a50; by upc; run; we know that writing all 50 files name is time consuming, is there any standard format of this code?

0 Answers   Symphony,


Categories