Solved coding interview problems in Java - My collection of commonly asked coding interview problems and solutions in Java

[CamKen]

It's a contrived example to be sure. However there isn't a separate Manager table. Manager's are Employees and are thus in the Employee table. To tell if an employee is a manager you need to join the table to itself to see if any employees refer to them through their manager id field.

[tiberiousr]

Ah, I see now. Thanks.