DB2 - Display the highest, lowest, sum, and average salary of all employees. Label the columns maximum, minimum, sum, and average, respectively, for each DEPARTMENT_ID

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

SELECT DEPARTMENT_ID, MAX(SALARY) MAXIMUM, MIN(SALARY) MINIMUM, SUM(SALARY) SUM, AVG(SALARY) AVARAGE
FROM EMPLOYEES
Group BY DEPARTMENT_ID

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Write a query to display the number of peopl ...

Next > : DB2 - Display the LAST_NAME of all employees where ...

Comments or Responses

More Interview Questions by Bandi

DB2 - Display the LAST_NAME of all employees where the third letter of ...
DB2 - Display the LAST_NAME of all employees where the first letter of ...
DB2 - Display the DEPARTMENT_ID &DEPARTMENT_NAME from DEPARTMENTS ...
DB2 - Display the LAST_NAME and HIRE_DATE of every employee who was hi ...
DB2 - Display the employee LAST_NAME, DEPARTMENT_ID and HIRE_DATE of e ...
DB2 - Display the LAST_NAME concatenated with DEPARTMENT_ID, separated ...
which of the following function calculates the cumulative distribution ...
what is the output of SELECT CHOOSE (0, 1, 2, 3)?

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 ...