Using the NOT Operator

In order to cancel the condition, you need to use the keyword NOT.

The NOT operator is essential when you want to exclude certain records from your query results. It allows you to specify conditions that should not be met, effectively filtering out unwanted data. This can be particularly useful in scenarios where you need to focus on a subset of data that does not meet specific criteria.

First, let’s look at the syntax:

sql

Now let's look at the example:


              123
            
SELECT name, capital
FROM country
WHERE NOT continent='Asia';

Explanation: The NOT operator rejects the condition here; hence, it matches the continent to anything that is not Asia.

Here is the country table we are working with:

Oppgave

Swipe to start coding

Write an SQL query to get the name and capital columns from the country table (please retrieve these columns in this order). These countries must be not from the 'South America' continent.

Note

Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.

Løsning

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 4. Kapittel 5

Using the NOT Operator

In order to cancel the condition, you need to use the keyword NOT.

First, let’s look at the syntax:

sql

Now let's look at the example:


              123
            
SELECT name, capital
FROM country
WHERE NOT continent='Asia';

Explanation: The NOT operator rejects the condition here; hence, it matches the continent to anything that is not Asia.

Here is the country table we are working with:

Oppgave

Swipe to start coding

Write an SQL query to get the name and capital columns from the country table (please retrieve these columns in this order). These countries must be not from the 'South America' continent.

Note

Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.

Løsning

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 4. Kapittel 5

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor