Checking for NO Value

If a column doesn't contain any data, it's considered NULL. To determine if a value is NULL, you don’t just check for equality. Instead, you use the WHERE clause with IS NULL in a SELECT statement to find rows where the column’s value is NULL.

The syntax for it looks like this:

Let's illustrate this with an example:


              123
            
SELECT name
FROM country
WHERE region IS NULL;

Here is the country table we are working with:

Task

Swipe to show code editor

Write an SQL query that returns the name and capital columns with no population.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 6

Checking for NO Value

The syntax for it looks like this:

Let's illustrate this with an example:


              123
            
SELECT name
FROM country
WHERE region IS NULL;

Here is the country table we are working with:

Task

Swipe to show code editor

Write an SQL query that returns the name and capital columns with no population.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 6

Switch to desktop for real-world practiceContinue from where you are using one of the options below