SQL AND & OR Operators

The AND & OR Operators

The AND operator displays a record if both the first condition and the second condition is true.
The OR operator displays a record if either the first condition or the second condition is true.

---

SELECT * FROM Persons WHERE FirstName='Tove'  AND LastName='Svendson'


SELECT * FROM Persons WHERE FirstName='Tove' OR FirstName='Ola'