Course Content
Introduction to SQL
Introduction to SQL
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:
SELECT name FROM country WHERE region IS NULL;
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query that returns the name
and capital
columns with no population.
Thanks for your feedback!
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:
SELECT name FROM country WHERE region IS NULL;
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query that returns the name
and capital
columns with no population.
Thanks for your feedback!
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:
SELECT name FROM country WHERE region IS NULL;
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query that returns the name
and capital
columns with no population.
Thanks for your feedback!
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:
SELECT name FROM country WHERE region IS NULL;
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query that returns the name
and capital
columns with no population.