Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Number filtering | Filtering
SQL Basics
Sektion 2. Kapitel 2
single

single

bookNumber filtering

Stryg for at vise menuen

But what if we want to choose a car with small mileage, let it be less than 5000 miles. We need to set the condition to a numeric column.

This also can be done with WHERE statement. For example,


              
123

            
SELECT *
FROM audi_cars
WHERE mileage < 5000
copy

Comparison operators you also can use for numeric columns:

  • < - less than
  • <= - less-equal
  • >= - greater-equal -> - greater
  • = - equal
  • <> - not equal.

Now let's try to find the cheapest car in this dataset.

Opgave

Swipe to start coding

From the audi_cars dataset extract cars with price less than 10 000.

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 2
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

some-alt