datacamp-logo

WHERE AND OR

What if you want to select rows based on multiple conditions where some but not all of the conditions need to be met?

For this, SQL has the OR operator.

For example, the following returns all details from bank clients that are either 29 or 41 years old:

SELECT *
FROM clients
WHERE age = 29
OR age = 41;

Note that you need to specify the column for every OR condition!

When combining AND and OR, be sure to enclose the individual clauses in parentheses, like so:

SELECT *
FROM clients
WHERE (age = 29 OR age = 41)
AND (education = 'university degree' OR certification = 'R');

Otherwise, due to SQL's precedence rules, you may not get the results you're expecting!


What does the OR operator do?

Answer the question
50 XP
Possible Answers
  • press
  • press
  • press