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:

Opgave

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

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 4. Kapitel 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:

Opgave

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

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 4. Kapitel 5

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder