DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

Consider the employee table with column PROJECT

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions