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

Given an array all of whose elements are positive numbers, find the maximum sum of a subsequence with the constraint that no 2 numbers in the sequence should be adjacent in the array. So 3 2 7 10 should return 13 (sum of 3 and 10) or 3 2 5 10 7 should return 15 (sum of 3, 5 and 7)

0 Answers   Amazon,


How to swap two String values without using a third variable?

8 Answers   Infosys,


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  


Write a program to swap the content of two variables without using a third variable.

0 Answers   Zensar,


what is encapulation?

4 Answers   Syntel,






Tag for turning an image into a hyperlink is

0 Answers  


Why did you ever become involved in QA/testing?

0 Answers  


When we delete logfiles such as screenshots how does it affect the ldf file? Ive seen huge change while adding screenshots in the ldf file but a very minor one deleting them.Please Explain

0 Answers  


Compare any 4 software development life cycle paradigms with each other. Indicate at least one application for each of the paradigms that are suitable to developed using that paradigm.

0 Answers  


Need guidewire related Documents(Interview Question/Tips/Best Practice/Dumps)

0 Answers  


Number of null pointers in any binary tree

5 Answers   Infosys,


In staad pro, how can we design ROOF SLAB?

0 Answers   L&T,


Categories