Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lära NOT like this! | Filtering
SQL Basics

bookNOT like this!

Often situation when we know what we don't want to find. In the case of numeric value, you should already know, that there is <> sign in SQL which means not equal. This also works for non-numeric columns: you can easily set <> 'some word' condition. But what if we want to avoid multiple non-numeric values? Or avoid some pattern?

Of course, it's already solved! There is NOT statement in SQL, which can be used with LIKE and IN statements. For example, we can filter cars in audi_table so there won't be Q-series cars.


              
123

            
SELECT *
FROM audi_cars
WHERE model NOT LIKE 'Q%'
copy

Please note, that NOT should be placed before IN or LIKE, like in spelling.

Uppgift

Swipe to start coding

Extract all the cars from the audi_cars table except A3, A4, and Q3 models.

Lösning

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 7
single

single

Fråga AI

expand

Fråga AI

ChatGPT

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

close

Awesome!

Completion rate improved to 2.63

bookNOT like this!

Often situation when we know what we don't want to find. In the case of numeric value, you should already know, that there is <> sign in SQL which means not equal. This also works for non-numeric columns: you can easily set <> 'some word' condition. But what if we want to avoid multiple non-numeric values? Or avoid some pattern?

Of course, it's already solved! There is NOT statement in SQL, which can be used with LIKE and IN statements. For example, we can filter cars in audi_table so there won't be Q-series cars.


              
123

            
SELECT *
FROM audi_cars
WHERE model NOT LIKE 'Q%'
copy

Please note, that NOT should be placed before IN or LIKE, like in spelling.

Uppgift

Swipe to start coding

Extract all the cars from the audi_cars table except A3, A4, and Q3 models.

Lösning

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 7
single

single

close

Awesome!

Completion rate improved to 2.63

bookNOT like this!

Svep för att visa menyn

Often situation when we know what we don't want to find. In the case of numeric value, you should already know, that there is <> sign in SQL which means not equal. This also works for non-numeric columns: you can easily set <> 'some word' condition. But what if we want to avoid multiple non-numeric values? Or avoid some pattern?

Of course, it's already solved! There is NOT statement in SQL, which can be used with LIKE and IN statements. For example, we can filter cars in audi_table so there won't be Q-series cars.


              
123

            
SELECT *
FROM audi_cars
WHERE model NOT LIKE 'Q%'
copy

Please note, that NOT should be placed before IN or LIKE, like in spelling.

Uppgift

Swipe to start coding

Extract all the cars from the audi_cars table except A3, A4, and Q3 models.

Lösning

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

some-alt