通过 SQL，从 “actor” 表中选取 "FirstName" 列的值等于"John" 的所有记录的表述正确的是（ ）。 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，根据 "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

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

从"actor"表中选取"FirstName"列的SQL语句是()。 A: select actor.FirstName B: select FirstName from actor C: extract FirstName from actor D: update FirstName from actor