单项选择题

通过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'

微信扫码免费搜题