Beginner

372. IS NOT NULL

Learn how to find rows where a column contains a value instead of NULL.

📘 Lesson 372 of 728 ⏱ 8 min 🎯 Beginner

IS NOT NULL checks whether a column or expression contains a non-NULL value.

It helps analysts identify complete records and exclude missing information from analysis.

Find employees who have a manager assigned.

SQL 
SELECT
    EmployeeName,
    ManagerID
FROM Employees
WHERE ManagerID IS NOT NULL;

IS NOT NULL is useful for completeness checks, reporting filters, validation, and preparing datasets for analysis.

  • IS NOT NULL finds available values.
  • It excludes NULL values.
  • It is useful for completeness checks.
  • It can be combined with other conditions.
  • NULL is not the same as an empty string.
What does IS NOT NULL do?

It returns rows where the specified column or expression is not NULL.

When is IS NOT NULL useful?

It is useful when you need records containing required or available information.

Have you finished this lesson?

Introduction to SQL – All Lessons