Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
See the whole table
Select some columns
Filtering rows
Logic
9. Logical operators – OR
Text patterns
To be or NULL to be
A little 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;

We've added a new OR clause which allows us to join more conditions.

In this case, we only select those users who are above 50 years old or under 185 cm of height. In other words, a row is displayed when the first condition or the second condition is true. Note that if both conditions are true, the row is also displayed.

Exercise

Select vins of all cars which were produced before 2005 or whose price is below $10,000.

Stuck? Here's a hint!

Type:

SELECT vin
FROM car
WHERE production_year < 2005
  OR price < 10000;