You can use
OR logical operator with
OR operator separates the multiple conditions.
At least one condition should be true to get the result set.
WHERE condtionA OR condtionB OR conditionC
Select the name list of employees whose age is greater than 40 or salary is greater than 100,000
SELECT name FROM employees WHERE age > 40 OR salary > 100000