Query

Question

Comments

Yes it should be B.

because first it is finding dept with largest budget. Then managerid of that dept. then in the outer. Query by assuming that some employees are managers then we are comparing empid with manager id’s and hence only names of those employees who are manager of largest budget dept will be displayed

---

Sir Ive a dout... Are Dept D and Dept D2 are seperate tables?

---

NO Dept is a single table aliases as D and D2

Answer 1

B should be the answer.

First of all the innermost query will find the department with the largest budget.

secondly the next layer query will find the managers of that department.

And finally as these managers will itself be employees so they are selected by matching there ids at the top layer.

Comments

can u explain a bit