IS NOT NULL

Edit on GitHub

The IS NOT NULL operator checks if a value is not equal to NULL.

Syntax

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

Example

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

SELECT *
FROM customers
WHERE birthday IS NOT NULL;

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.
Edit on GitHub

Learn SQL on Codecademy

Skill path

Analyze Data with SQL

Learn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
With Certificate
Beginner Friendly
15 Lessons
Skill path

Design Databases With PostgreSQL

Learn how to create and optimize a database from scratch using PostgreSQL
Includes 5 Courses
With Certificate
Beginner Friendly
11 Lessons
Free course

Learn SQL

In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.
Beginner Friendly
4 Lessons
Edit on GitHub

Contributors