DB2 - Display the DEPARTMENT_ID &DEPARTMENT_NAME from DEPARTMENTS table which does not have a manager

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

SELECT DEPARTMENT_ID , DEPARTMENT_NAME
FROM DEPARTMENTS
WHERE MANAGER_ID IS NULL


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response