1.

Suppose we wish to find the ID s of the employees that are managed by people who are managed by the employee with ID 123. Here are two possible queries:I.SELECT ee.empID FROM Emps ee, Emps ff WHERE ee.mgrID = ff.empID AND ff.mgrID = 123;II.SELECT empID FROM Emps WHERE mgrID IN (SELECT empID FROM Emps WHERE mgrID = 123);Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID s?

A. Both I and II
B. I only
C. II only
D. Neither I nor I
Answer» B. I only


Discussion

No Comment Found