SQL IS NULL

Published Jun 25, 2021Updated Aug 18, 2022

Contribute to Docs

The IS NULL operator checks if a value is NULL.

Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Includes 9 Courses
With Certificate
Beginner Friendly.
17 hours
Skill path
Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses
With Certificate
Beginner Friendly.
13 hours

Syntax

SELECT column_name(s)
FROM table_name
WHERE condition IS NULL;

Copy to clipboardCopy to clipboard

Example

The given query will select all customers who do not have a birthday stored in the database.

SELECT *
FROM customers
WHERE birthday IS NULL;

Copy to clipboardCopy to clipboard

All contributors

Contribute to Docs

Learn more about how to get involved.
Edit this page on GitHub to fix an error or make an improvement.
Submit feedback to let us know how we can improve Docs.

Learn SQL on Codecademy

Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Includes 9 Courses
With Certificate
Beginner Friendly.
17 hours
Skill path
Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses
With Certificate
Beginner Friendly.
13 hours