SQL IS NOT NULL

Published Jun 25, 2021Updated Aug 18, 2022

The IS NOT NULL operator checks if a value is not equal to 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 NOT NULL;

Copy to clipboardCopy to clipboard

Example

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

SELECT *
FROM customers
WHERE birthday IS NOT NULL;

Copy to clipboardCopy to clipboard

All contributors

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