通过 SQL,您如 Persons 中选择 FirstName 等于 Thomas 而 LastName 等于 Carter 的所有记录?
A.
SELECT * FROM Persons WHERE FirstName LIKE 'Thomas' AND LastName LIKE 'Carter'
B.
SELECT FirstName='Thomas', LastName='Carter' FROM Persons
C.
SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'
D.
SELECT * FROM Persons WHERE FirstName='Thomas' OR LastName='Carter'