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
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, 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!