IS NOT NULL
Published Jun 25, 2021Updated Aug 18, 2022
Contribute to Docs
IS NOT NULL operator checks if a value is not equal to
SELECT column_name(s)FROM table_nameWHERE condition IS NOT NULL;
The given query will select all customers who have a
birthday stored in the database.
SELECT *FROM customersWHERE birthday IS NOT NULL;
- christian.dinh2481 total contributions
- Anonymous contributorAnonymous contributor3077 total contributions
- JeremyBarbosa18 total contributions
Learn SQL on Codecademy
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses