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: 1625 | Points: 40

Answer:

SELECT DEPARTMENT_ID , DEPARTMENT_NAME
FROM DEPARTMENTS
WHERE MANAGER_ID IS NULL

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Display the LAST_NAME of all employees where ...

Next > : DB2 - Display the LAST_NAME and HIRE_DATE of every ...

More Interview Questions by Bandi

Latest Interview Questions