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:

Compito

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.

Soluzione

Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti

Tutto è chiaro?

Grazie per i tuoi commenti!

Sezione 4. Capitolo 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:

Compito

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.

Soluzione

Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti

Tutto è chiaro?

Grazie per i tuoi commenti!

Sezione 4. Capitolo 5

Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti