> > >

DB2 Programming MCQs

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

SELECT EMPNO FROM EMP

WHERE MGR IS NULL;

SELECT EMPNO FROM EMP

WHERE MGR=NULL;

SELECT EMPNO FROM EMP

WHERE MGR=0;

None of the above

Answer

Correct Answer:

SELECT EMPNO FROM EMP

WHERE MGR IS NULL;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Programming Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it