Number filtering
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,
123SELECT * FROM audi_cars WHERE mileage < 5000
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.
Swipe to start coding
From the audi_cars dataset extract cars with price less than 10 000.
Solution
Merci pour vos commentaires !
single
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion
Génial!
Completion taux amélioré à 2.63Number filtering
Glissez pour afficher le menu
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,
123SELECT * FROM audi_cars WHERE mileage < 5000
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.
Swipe to start coding
From the audi_cars dataset extract cars with price less than 10 000.
Solution
Passez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessousMerci pour vos commentaires !
single
