Returning all data from a table
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
A bit of mathematics
Let's practice
Instruction
Good. Now, if you want to find users who are older than 13 and younger than 70, you can of course use the approach in the previous example:
SELECT Id, Name FROM User WHERE Age <= 70 AND Age >= 13;
But there is also another approach. Take a look:
SELECT Id, Name FROM User WHERE Age BETWEEN 13 AND 70;
We introduced a new keyword BETWEEN. In this case, we look for rows with the age column set to any value between 13 and 70, including these values.
Exercise
Select the Vin, Brand, and Model of all cars that were produced between 1995 and 2005, inclusive.
Stuck? Here's a hint!
Type:
SELECT Vin, Brand, Model FROM Car WHERE ProductionYear BETWEEN 1995 AND 2005;
