通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。? SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter'|SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'|SELECT FirstName='Jim', LastName='Carter' FROM Actor|SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter'
举一反三
- 通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'
- 通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'
- 通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'
- 通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter' B: SELECT FirstName='Jim', LastName='Carter' FROM Actor C: SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter' D: SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'
- 通过 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'