EasyWHERE & Filtering
Find employees with no manager (top-level)
The query
SQL
SELECT emp_id, first_name, last_name, job_title
FROM employees
WHERE manager_id IS NULL;Note
“IS NULL finds rows where the value is absent. These are likely CEOs/VPs.
SELECT emp_id, first_name, last_name, job_title
FROM employees
WHERE manager_id IS NULL;Note
“IS NULL finds rows where the value is absent. These are likely CEOs/VPs.