Contenido del Curso
SQL Basics
SQL Basics
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,
SELECT * 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 show code editor
From the audi_cars
dataset extract cars with price
less than 10 000.
¡Gracias por tus comentarios!
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,
SELECT * 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 show code editor
From the audi_cars
dataset extract cars with price
less than 10 000.
¡Gracias por tus comentarios!
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,
SELECT * 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 show code editor
From the audi_cars
dataset extract cars with price
less than 10 000.
¡Gracias por tus comentarios!
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,
SELECT * 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 show code editor
From the audi_cars
dataset extract cars with price
less than 10 000.