IS NOT NULL

Checks if a value is not 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;
Edit this page on GitHub

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your feedback.

Learn SQL on Codecademy

Edit this page on GitHub

Contributors