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

what is the difference between SCAN AND CHECK,LOKUP AND XFOOT? where we can use thease opcodes? Can any body tell me real time senariao with example?

0 Answers  


through which algorithm does the garbage collector works? how the garbage collector will understand that the object will going to be deleted?

0 Answers   Motorola,


I am looking for selenium RC online Training in chennai. can any one tell me the best institute

0 Answers  


What is a dialog based program

1 Answers  


Hi can you please send me recent(present) interview questions and technical qyestions with answers for "BUSSIESS OBJECTS" and "DATA WAREHOUSE".pls its urgent for me my mail id is sekhar.cs82@gmail.com,manjuforgis@gmail.com. thanks in advance

0 Answers  






What is the use of Differ interface check box in Ship confirm?

0 Answers  


THERE ARE 4 SOURCE FILES WHICH CONTAINS SAME METADATA CREATE A TARGET THAT SHOULD DISPLAY THE FILE NAME ALONG WITH THE RECORD PLEASE SEND THE ANSWERFOR THIS QUESTION WITH MAPPING

0 Answers   Wipro,


what is the difference between a namespace and assembly ?

4 Answers   Innominds, Polaris,


MOV.CB 007H,ADCON1 MOVE.CT 001H,_OPTION_REG_7 MOV.CB 007H,CMCON

0 Answers  


Colors specified with the notation

0 Answers  


What is a singleton linked list?

1 Answers   Wipro,


how many types of operating system are avaliable?

0 Answers   IBM,


Categories