Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Using the OR operator | Advanced Data Filtering
Introduction to SQL
course content

Course Content

Introduction to SQL

Introduction to SQL

1. Retrieving Data
2. Sorting Retrieved Data
3. Filtering Data
4. Advanced Data Filtering
5. Aggregate Functions

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

Let's look at the example:

123
SELECT name, population, continent, region FROM country WHERE continent = 'Asia' OR continent = 'Europe';
copy

Here is the country table we are working with:

Task
test

Swipe to show code editor

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 as North America, and asia is not the same as Asia. Be careful and write correctly: North America and Asia.

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 4. Chapter 3
toggle bottom row

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

Let's look at the example:

123
SELECT name, population, continent, region FROM country WHERE continent = 'Asia' OR continent = 'Europe';
copy

Here is the country table we are working with:

Task
test

Swipe to show code editor

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 as North America, and asia is not the same as Asia. Be careful and write correctly: North America and Asia.

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 4. Chapter 3
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