IS NOT NULL

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.

Learn SQL on Codecademy