News for hackers. Stuff that matters.
Re:Our SQL interview questions by genwin on Tuesday May 28, 2013 @02:04PM (#5781540)
On the first and fourth queries you don't need LEFT JOIN because the WHERE clause guarantees that only INNER JOIN rows will match. (Presumably neither question applies to the top person.)

On the third one you don't list all departments; the empty ones are filtered out. Needs a LEFT JOIN.

There are no comments on this comment yet.