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?
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.