Home
/
Questions
/
Coding
/
Which departments have no employees?
caseSQL
Coding question · Left Join Null
Medium
Asked at Facebook
Which departments have no employees?
LEFT JOIN + IS NULL to find rows on the left side with no match on the right.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Unique customers ordering each month
Next →
Employees earning above their department average