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:

sql

Let's look at the example:


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

Here is the country table we are working with:

Tehtävä

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

Ratkaisu

Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 4. Luku 3

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:

sql

Let's look at the example:


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

Here is the country table we are working with:

Tehtävä

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

Ratkaisu

Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 4. Luku 3

Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista