Interview Questions

Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?

DB2 INTERVIEW QUESTIONS

(Continued from previous question...)

Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?

SELECT EMPNO
FROM EMP
WHERE PROJECT IS NULL;

(Continued on next question...)

Other Interview Questions