Page 175 - SQL

using OR keyword

SELECT name FROM persons WHERE gender = 'M' OR age < 20;

This will return:

name

Sam

John

Bob

These keywords can be combined to allow for more complex criteria combinations:

SELECT name
FROM persons
WHERE (gender = 'M' AND age < 20)
OR (gender = 'F' AND age > 20);

This will return:

name

Sam

Mary

Read SELECT online: https://riptutorial.com/sql/topic/222/select

https://riptutorial.com/ 157