News for hackers. Stuff that matters.
Re:Our SQL interview questions by twistedpair on Tuesday May 28, 2013 @11:52AM (#5780720)
You assume that all people have bosses. The top boss has no boss. You also assume that all department names are unique.

Nitpicking, yes, but these questions certainly allow for a deeper discussion with the interviewer.

Re:Our SQL interview questions by brown9-2 on Tuesday May 28, 2013 @01:08PM (#5781175)
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.

Re:Our SQL interview questions by genwin on Tuesday May 28, 2013 @02:07PM (#5781560)
Two assumptions to be clarified in the interview: 4th question above doesn't apply to the top boss (who can't have a greater salary than a boss he/she doesn't have, so no issue on the 1st question). Department table has an alternate key on department name.