DB2 - Find the count of departments having average salary greater than maximum salary of department 50

Posted by Bandi on 11/30/2013 | Category: Others Interview questions | Views: 4250 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

SELECT COUNT (DEPARTMENT_ID) FROM
(SELECT DEPARTMENT_ID FROM EMPLOYEES GROUP BY DEPARTMENT_ID HAVING AVG (SALARY) > (SELECT MAX (SALARY) FROM EMPLOYEES
WHERE DEPARTMENT_ID=50)
)

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Find the NAMEs that have an even number of l ...

Next > : DB2 - Write a query to get the employee name who j ...

Comments or Responses

More Interview Questions by Bandi

DB2 - Write a query to get the employee name who joined the company re ...
DB2 - Write a query to get the employee name who joined the company re ...
DB2 - Display number of employees in each department, if the departmen ...
DB2 - Display minimum salary from each department
DB2 - Write a query to display employee name who gets highest salary
DB2 - Write down the syntax order & execution order of SELECT, FRO ...
DB2 - How FECH FIRST clause works. Give an example.
DB2 - Difference between DROP & TRUNCATE

Latest Interview Questions

What will happen,if we compile below code public interface intf_per ...
In VB.Net Overloads keyword is used for which type? Public Over ...
What is the best example of Function Overloading?
What will happen,if we compile below function? private double sum(i ...
What will happen,if we compile below function:- private double sum( ...
What will happen,if we compile below function? private double sum(i ...
What are the points which fulfill Function Overloading?
Does Function Overloading depend on Return Type?
More ...