Using the OR operator
The OR
operator is used to filter records based on more than one condition, like if you want to return all countries from Asia but also those from Europe.
Here is the syntax of using the OR operator:
SELECT columns
FROM table
WHERE column = 'first_option' OR column = 'second_option';
Let's look at the example:
123SELECT name, population, continent, region FROM country WHERE continent = 'Asia' OR continent = 'Europe';
Swipe to start coding
Write an SQL query to retrieve the name
of the countries that are from 'Asia' or 'North America' continent.
Note
Note that
north america
is not the same asNorth America
, andasia
is not the same asAsia
. Be careful and write correctly:North America
andAsia
.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.44Awesome!
Completion rate improved to 2.44
Using the OR operator
The OR
operator is used to filter records based on more than one condition, like if you want to return all countries from Asia but also those from Europe.
Here is the syntax of using the OR operator:
SELECT columns
FROM table
WHERE column = 'first_option' OR column = 'second_option';
Let's look at the example:
123SELECT name, population, continent, region FROM country WHERE continent = 'Asia' OR continent = 'Europe';
Swipe to start coding
Write an SQL query to retrieve the name
of the countries that are from 'Asia' or 'North America' continent.
Note
Note that
north america
is not the same asNorth America
, andasia
is not the same asAsia
. Be careful and write correctly:North America
andAsia
.
Solution
Thanks for your feedback!
single
Awesome!
Completion rate improved to 2.44
Using the OR operator
Swipe to show menu
The OR
operator is used to filter records based on more than one condition, like if you want to return all countries from Asia but also those from Europe.
Here is the syntax of using the OR operator:
SELECT columns
FROM table
WHERE column = 'first_option' OR column = 'second_option';
Let's look at the example:
123SELECT name, population, continent, region FROM country WHERE continent = 'Asia' OR continent = 'Europe';
Swipe to start coding
Write an SQL query to retrieve the name
of the countries that are from 'Asia' or 'North America' continent.
Note
Note that
north america
is not the same asNorth America
, andasia
is not the same asAsia
. Be careful and write correctly:North America
andAsia
.
Solution
Thanks for your feedback!