Beginner

123. IS NOT NULL

Learn how to find records where a column contains an actual value instead of NULL.

📘 Lesson 123 of 728 ⏱ 7 min 🎯 Beginner

IS NOT NULL is a SQL condition used to identify rows where a specified column contains a non-NULL value.

Analysts often need to exclude incomplete records and work only with rows where required information is available.

A customer report may include only customers who have provided an email address.

SQL 
SELECT
    CustomerID,
    CustomerName,
    Email
FROM Customers
WHERE Email IS NOT NULL;

IS NOT NULL is useful for data validation, reporting, customer segmentation, and filtering incomplete records.

  • IS NOT NULL identifies available values.
  • It excludes NULL records.
  • It is commonly used with WHERE.
  • It helps filter incomplete data.
  • It is useful for data-quality checks.
What does IS NOT NULL do?

It returns rows where the specified column contains a non-NULL value.

When would you use IS NOT NULL?

You can use it when you need records where a required or useful field contains an actual value.

Have you finished this lesson?

Introduction to SQL – All Lessons