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

Hi Guys, This is Rama, right now I am working as a Software Test Engineer in Gurgoan and I have over all 3 years of testing expoeriance. Right now I am looking for a change. Can any body help me out to find a job in south india. Thanks in Advance

0 Answers  


Is the IT field raise again? What is the position of IT after 4 years?

0 Answers  


How to use string functions in QTP?give some examples

1 Answers  


WHAT IS THE MEANING OF CONSTANT ...EXEEDS LENGTH LIMIT WHILE COPYING FROM PS FILE TO KSDS

0 Answers  


Have you used callsymputx? what points need to be kept in mind when using it?

0 Answers   GE,


what is the purpose of checked Menu options

0 Answers  


what is programmable BIST in today ic design

0 Answers   IIT,


when a query is made on Logical file in DB2/400, will the records satisfying select/omit criterion be fetched from all members of physical file or only the member with same name as physical file?

0 Answers  


class A{ void me(){s.o.p("");} class B extends A{ void me() {s.o.p(" ");} class M{ A a=new B(); B b=new A(); a.me(); b.mne();} what is the output of this, how?

2 Answers   Cosmos, HyTech Pro, WinSoft,


major characteristics of software system

0 Answers  


hi this is uday i want prepare for nic exam if any one have previous question papers please send me or atlest guide me how to prepare my ID is udaykiran4u@in.com

0 Answers  


I am work in it aompenei

0 Answers   Access Healthcare,


Categories