在SELECT命令中用于排序的短语是( ).
A: SORT
B: SORT BY
C: ORDER
D: ORDER BY
A: SORT
B: SORT BY
C: ORDER
D: ORDER BY
举一反三
- 排序可以有逻辑排序，也可以利用（）命令进行物理排序。 A: INDEX B: SORT C: INDEXON D: ORDER
- SELECT命令中用于排序的关键词是（） A: GROUP BY B: ORDER BY C: HAVING D: SELECT
- 通过 SQL，您如何根据 "FirstName" 列降序地从 "Persons" 表返回所有记录？ A: SELECT * FROM Persons SORT 'FirstName' DESC B: SELECT * FROM Persons ORDER BY FirstName DESC C: SELECT * FROM Persons ORDER FirstName DESC D: SELECT * FROM Persons SORT BY 'FirstName' DESC
- 通过 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
- 对查询结果指定排序依据的子句是（）。 A: ORDER BY B: GROUP BY C: GRANT BY D: SORT BY