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.
On the third one you don't list all departments; the empty ones are filtered out. Needs a LEFT JOIN.