📝 Question
#1257
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);
✓
Correct Answer
A. Both I and II
💡
Explanation
The query can be satisfied by any of the two options.
⌨️ Press
A
B
C
D
to select