Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Checking for NO Value | Filtering Data
Introduction to SQL

Swipe to show menu

book
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:

sql

Let's illustrate this with an example:

123
SELECT name FROM country WHERE region IS NULL;
copy

Here is the country table we are working with:

Task

Swipe to start coding

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

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 6

Ask AI

expand
ChatGPT

Ask anything or try one of the suggested questions to begin our chat

book
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:

sql

Let's illustrate this with an example:

123
SELECT name FROM country WHERE region IS NULL;
copy

Here is the country table we are working with:

Task

Swipe to start coding

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

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 6
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt