AND 运算符
SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'
OR 运算符
SELECT * FROM Persons WHERE firstname='Thomas' OR lastname='Carter'
结合 AND 和 OR 运算符
SELECT * FROM Persons WHERE (FirstName='Thomas' OR FirstName='William')
AND LastName='Carter'