In the Select statement of the SQL language, the clause that used to indicate the order of the query result is ().
A: From
B: While
C: Group By
D: Order By
A: From
B: While
C: Group By
D: Order By
举一反三
- In SQL query, order by clause is used to achieve grouping.
- In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（） A: AImmediately after the SELECT clause B: BBefore the WHERE clause C: CBefore the FROM clause D: DAfter the ORDER BY clause E: EAfter the WHERE clause
- 以下SQL子句的撰写顺序表达正确的是： A: SELECT、FROM、WHERE、GROUP BY、HAVING、ORDER BY B: SELECT、FROM、WHERE、HAVING、GROUP BY、ORDER BY C: SELECT、FROM、WHERE、ORDER BY、HAVING、GROUP BY D: SELECT、FROM、ORDER BY、WHERE、GROUP BY、HAVING
- Regarding the sort clause of the SQL language SELECT command, the following statement () is wrong. A: The suffix DESC indicates descending order B: The suffix ASC indicates ascending order C: The default suffix indicates ascending order D: The default suffix indicates descending order
- 把查询语句的各个子句按执行的先后顺序排列，正确的是( ) A: FROM→WHERE→GROUP BY→SELECT→ORDER BY B: SELECT→FROM→WHERE→GROUP BY→ORDER BY C: WHERE→FROM→SELECT→GROUP BY→ORDER BY D: FROM→WHERE→SELECT→ORDER BY→GROUP BY