You assume that all people have bosses. The top boss has no boss.
Isn't that why a left outer join is used?
Besides, if you are referring to question #1, a person without a boss can never be a part of the set of employees who have a higher salary than their boss.
Isn't that why a left outer join is used?
Besides, if you are referring to question #1, a person without a boss can never be a part of the set of employees who have a higher salary than their boss.