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
Up until now, we were able to filter the rows in the previous examples using conditional operators (=, !=, <, >, <=, >=). But what about situations when we want to be really picky and join a few conditions?
SELECT Id, Name FROM User WHERE Age > 50 OR Height < 185;
In the above query, we added a new OR clause that allows us to join more conditions.
In this case, we only select those users who are older than 50 or under 185 cm in height. In other words, a row will appear in the result set when either the first or second condition is true for that row. Of course, if both conditions are true, the row will still be displayed.
Exercise
Select the Vin of all cars produced before 2005 or priced at less than 10,000.
Stuck? Here's a hint!
Type:
SELECT Vin FROM Car WHERE ProductionYear < 2005 OR Price < 10000.00;
