Title - IS NULL SQL operators Tags - sql operators programming
Unknwon values are indicated by NULL.
We can use these operators to return results with a value
IS NULL
or without a value
IS NOT NULL
Example:
SELECT name FROM movies WHERE imdb_rating IS NOT NULL;
Will retun movies that DO have a value in the imdb_rating column.
SELECT name FROM movies WHERE imdb_rating IS NULL;
Will retun movies that DO NOT have a value in the imdb_rating column.