通过 SQL，您如何在 "Persons" 表中删除 "FirstName" 等于 "Fred" 的纪录？
A: DELETE FROM Persons WHERE FirstName = 'Fred'
B: DELETE FirstName='Fred' FROM Persons
C: DELETE ROW FirstName='Fred' FROM Persons
A: DELETE FROM Persons WHERE FirstName = 'Fred'
B: DELETE FirstName='Fred' FROM Persons
C: DELETE ROW FirstName='Fred' FROM Persons
举一反三
- 通过 SQL，在 "Actor" 表中删除 "FirstName" 等于 "Fred" 的记录的描述正确的是（）。 A: DELETE FirstName='Fred' FROM Actor B: DELETE ROW FirstName='Fred' FROM Actor C: DELETE Actor WHERE FirstName = 'Fred' D: DELETE FROM Actor WHERE FirstName = 'Fred'
- 通过 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" 列的值等于"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'
- 通过 SQL，您如何从 "Persons" 表中选取 "FirstName" 列？ A: SELECT Persons.FirstName B: SELECT FirstName FROM Persons C: EXTRACT FirstName FROM Persons
- 通过 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'