IS NOT NULL

How can we return only employees who have an assigned manager?

Advanced⏱ 3 Minutes⭐ 1310 XP

🤔 THE QUESTION

How can we return only employees who have an assigned manager?

💡 WHAT IS IT?

IS NOT NULL filters for rows with populated, non-missing data.

🎯 WHAT IS IT USED FOR?

Valid record processing, verified user rosters, assigned task analysis.

💻 EXAMPLE

SELECT name
FROM employees
WHERE manager_id IS NOT NULL;

Practice typing production-grade SQL code for IS NOT NULL.