同时使用AND和OR运算符的SQL语句Sample如下:
SELECT * FROM Persons WHERE (FirstName='Thomas' OR FirstName='William') AND LastName='Carter';
(
OR
)
AND