通过 SQL,您如何按字母顺序选取 Persons 表中 LastName 介于 Adams 和 Carter 的所有记录?
举一反三
- 通过 SQL，您如何按字母顺序选取 Persons 表中 LastName 介于 Adams 和 Carter 之间（含其本身）的所有记录？ A: SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter' B: SELECT * FROM Persons WHERE LastName>'Adams' AND LastName C: SELECT LastName>'Adams' AND LastName
- 通过 SQL，按字母顺序选取 Actor 表中 LastName 介于 Adams 和 Carter 的所有记录的表述正确的是（ ）。 A: SELECT * FROM Actor WHERE LastName BETWEEN 'Adams' AND 'Carter' B: SELECT * FROM Actor WHERE LastName>'Adams' AND LastName<'Carter' C: SELECT LastName>'Adams' AND LastName<'Carter' FROM Actor D: SELECT * FROM Actor WHERE LastName>'Adams' OR LastName<'Carter'
- 通过 SQL，按字母顺序选取 Actor 表中 LastName 介于 Adams 和 Carter 的所有记录的表述正确的是（ ）。? SELECT * FROM Actor WHERE LastName BETWEEN 'Adams' AND 'Carter'|SELECT LastName>'Adams' AND LastName<'Carter' FROM Actor|SELECT * FROM Actor WHERE LastName>'Adams' AND LastName<'Carter'|SELECT * FROM Actor WHERE LastName>'Adams' 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'
- 通过 SQL，您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ？ A: INSERT INTO Persons (LastName) VALUES ('Wilson') B: INSERT ('Wilson') INTO Persons (LastName) C: INSERT INTO Persons ('Wilson') INTO LastName