Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Combining conditions | Filtering
SQL Basics

bookCombining conditions

Often it's not enough to check for only one condition. What if we want to check if multiple conditions hold at the same time? Or at least one of them?

Conditions in SQL can be combined by using AND and OR statements within WHERE block. AND checks if all the conditions hold while OR checks if at least one of the conditions holds. For example, we can combine conditions from the two previous chapters: filter for hybrid cars with mileage less than 5000 miles.


              
123

            
SELECT *
FROM audi_cars
WHERE fueltype = 'Hybrid' AND mileage < 5000
copy

Also, we can extract only either cars with Automatic transmission either with an engine size less than 3 by using OR statement.


              
123

            
SELECT *
FROM audi_cars
WHERE transmission = 'Automatic' OR enginesize < 3
copy
Opgave

Swipe to start coding

From audi_cars table extract only Diesel cars (fueltype column) with mileage less than 2000.

Løsning

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 2. Kapitel 3
single

single

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Suggested prompts:

Opsummér dette kapitel

Explain code

Explain why doesn't solve task

close

Awesome!

Completion rate improved to 2.63

bookCombining conditions

Stryg for at vise menuen

Often it's not enough to check for only one condition. What if we want to check if multiple conditions hold at the same time? Or at least one of them?

Conditions in SQL can be combined by using AND and OR statements within WHERE block. AND checks if all the conditions hold while OR checks if at least one of the conditions holds. For example, we can combine conditions from the two previous chapters: filter for hybrid cars with mileage less than 5000 miles.


              
123

            
SELECT *
FROM audi_cars
WHERE fueltype = 'Hybrid' AND mileage < 5000
copy

Also, we can extract only either cars with Automatic transmission either with an engine size less than 3 by using OR statement.


              
123

            
SELECT *
FROM audi_cars
WHERE transmission = 'Automatic' OR enginesize < 3
copy
Opgave

Swipe to start coding

From audi_cars table extract only Diesel cars (fueltype column) with mileage less than 2000.

Løsning

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 2. Kapitel 3
single

single

some-alt