Reported in a candidate post, Aug 2020
Find department name with zero employees
Filed under Oracle
The question
Given Employee and Department tables, write an SQL query to find the names of all departments that currently have 0 employees.
No write-up yet. Related questions below have one.
Related Oracle questions
Collected from public candidate posts and coding forums. Updated Nov 2026.