DB2 - Display minimum salary from each department

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

SELECT DEPARTMENT_ID, MIN(SALARY) “MIN SAL FOR EACH DEPARTMENT”
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response