A: SELECT [all] FROM Actor WHERE FirstName LIKE 'John'
B: SELECT [all] FROM Actor WHERE FirstName='John'
C: SELECT * FROM Actor WHERE FirstName LIKE 'John'
D: SELECT * FROM Actor WHERE FirstName='John'
举一反三
- 通过 SQL，从 “actor” 表中选取 "FirstName" 列的值等于"John" 的所有记录的表述正确的是（ ）。? SELECT * FROM Actor WHERE FirstName='John'|SELECT * FROM Actor WHERE FirstName LIKE 'John'|SELECT [all] FROM Actor WHERE FirstName='John'|SELECT [all] FROM Actor WHERE FirstName LIKE 'John'
- 通过 SQL，从 "Actor" 表中选取 "FirstName" 列的值以 "a" 开头的所有记录的表述正确的是（ ）。 A: SELECT * FROM Actor WHERE FirstName='%a%' B: SELECT * FROM Actor WHERE FirstName='a' C: SELECT * FROM Actor WHERE FirstName LIKE '%a' D: SELECT * FROM Actor WHERE FirstName LIKE 'a%'
- 通过 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'
内容
- 0
通过 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'
- 1
通过 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'
- 2
通过 SQL，根据 "FirstName" 列降序地从 "Actor" 表返回所有记录的正确表述是 A: SELECT * FROM Actor SORT BY 'FirstName' DESC B: SELECT * FROM Actor ORDER FirstName DESC C: SELECT * FROM Actor SORT 'FirstName' DESC D: SELECT * FROM Actor ORDER BY FirstName DESC
- 3
从"actor"表中选取"FirstName"列的SQL语句是()。 A: select actor.FirstName B: select FirstName from actor C: extract FirstName from actor D: update FirstName from actor
- 4
通过 SQL，您如何从 "Persons" 表中选取 "FirstName" 列的值等于"Peter" 的所有记录？ A: SELECT [all] FROM Persons WHERE FirstName='Peter' B: SELECT * FROM Persons WHERE FirstName LIKE 'Peter' C: SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' D: SELECT * FROM Persons WHERE FirstName='Peter'