通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列的值以 "a" 开头的所有记录?
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
举一反三
- 通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列的值等于"Peter" 的所有记录?
- 通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列的值以 "a" 开头的所有记录? A: SELECT * FROM Persons WHERE FirstName LIKE 'a%' B: SELECT * FROM Persons WHERE FirstName='a' C: SELECT * FROM Persons WHERE FirstName LIKE '%a' D: SELECT * FROM Persons WHERE FirstName='%a%'
- 通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列?
- 通过 SQL,您如何根据 "FirstName" 列降序地从 "Persons" 表返回所有记录?
- 通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列? A: SELECT Persons.FirstName B: SELECT FirstName FROM Persons C: EXTRACT FirstName FROM Persons
内容
- 0
通过 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'
- 1
通过SQL,您如何根据“FirstName”列降序地从“Persons”表返回所有记录?() A: A B: B C: C D: D
- 2
通过SQL,您如何根据“FirstName”列降序地从“Persons”表返回所有记录?() A: A B: B C: C D: D
- 3
通过SQL,您如何根据“FirstName”列降序地从“Persons”表返回所有记录?() A: A B: B C: C D: D
- 4
通过SQL,您如何根据“FirstName”列降序地从“Persons”表返回所有记录?() A: A B: B C: C D: D