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

Sveip for å vise menyen

book
Filtering by numeric interval

But what if we have a bounded budget and need to choose cars in a specific price range? Simply, we can set two conditions: price > minimum value AND price < maximum value.

Yes, that will work. But SQL provides us with a simple solution to this problem - using BETWEEN statement. The condition above can be rewritten in SQL query as BETWEEN minimum value AND maximum value. For example, we can choose cars with mileage from 1000 to 5000 miles.


              
123

            
SELECT *
FROM audi_cars
WHERE mileage BETWEEN 1000 AND 5000
copy

Please note, that both limits are included (i.e. it's equvivalent to 1000 <= mileage <= 5000).

Oppgave

Swipe to start coding

From the audi_cars table extract all the cars with prices (column price) in the range [12 000; 15 000].

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 2. Kapittel 4
Vi beklager at noe gikk galt. Hva skjedde?

Spør AI

expand
ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

book
Filtering by numeric interval

But what if we have a bounded budget and need to choose cars in a specific price range? Simply, we can set two conditions: price > minimum value AND price < maximum value.

Yes, that will work. But SQL provides us with a simple solution to this problem - using BETWEEN statement. The condition above can be rewritten in SQL query as BETWEEN minimum value AND maximum value. For example, we can choose cars with mileage from 1000 to 5000 miles.


              
123

            
SELECT *
FROM audi_cars
WHERE mileage BETWEEN 1000 AND 5000
copy

Please note, that both limits are included (i.e. it's equvivalent to 1000 <= mileage <= 5000).

Oppgave

Swipe to start coding

From the audi_cars table extract all the cars with prices (column price) in the range [12 000; 15 000].

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 2. Kapittel 4
Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Vi beklager at noe gikk galt. Hva skjedde?
some-alt