IS NULL

How can we find records with missing manager assignments?

Advanced⏱ 3 Minutes⭐ 1300 XP

🤔 THE QUESTION

How can we find records with missing manager assignments?

💡 WHAT IS IT?

IS NULL tests whether a column contains missing or unassigned values.

🎯 WHAT IS IT USED FOR?

Finding unassigned accounts, top-level executives without managers, missing contact data.

💻 EXAMPLE

SELECT name
FROM employees
WHERE manager_id IS NULL;

Practice typing production-grade SQL code for IS NULL.