通过 SQL返回 "Actor" 表中记录的数目的表述正确的是（）。
A: SELECT COUNT(*) FROM Actor
B: SELECT COLUMNS(*) FROM Actor
C: SELECT COLUMNS() FROM Actor
D: SELECT COUNT() FROM Actor
A: SELECT COUNT(*) FROM Actor
B: SELECT COLUMNS(*) FROM Actor
C: SELECT COLUMNS() FROM Actor
D: SELECT COUNT() FROM Actor
举一反三
- 通过 SQL返回 "Actor" 表中记录的数目的表述正确的是（）。? SELECT COUNT() FROM Actor|SELECT COUNT(*) FROM Actor|SELECT COLUMNS(*) FROM Actor|SELECT COLUMNS() FROM Actor
- 通过 SQL返回 "Actor" 表中记录的数目的表述正确的是（）。 A: SELECT COLUMNS() FROM Actor B: SELECT COLUMNS(*) FROM Actor C: SELECT COUNT() FROM Actor D: SELECT COUNT(*) FROM Actor
- 通过 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，从 "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，根据 "FirstName" 列降序地从 "Actor" 表返回所有记录的正确表述是（）。 A: SELECT * FROM Actor SORT 'FirstName' DESC B: SELECT * FROM Actor ORDER BY FirstName DESC C: SELECT * FROM Actor ORDER FirstName DESC D: SELECT * FROM Actor SORT BY 'FirstName' DESC