Support for constants in ORDER BY clause have been depreciated.
支持ORDER BY子句中使用常量已经过时。
Ordernames (string) is the SQL order by clause of a Select statement.
Ordernames(字符串)是Select语句的SQLorder by子句。
XMLAGG functions use the ORDER BY clause to sort the elements within the group.
xmlagg函数使用ORDER BY子句对组内元素进行排序。
The ORDER BY clause specifies how the data is sorted within each group (partition).
ORDER BY(按…排序)语句规定了每个分组(划分)的数据如何排序。
Our next example, shown in Figure 2, is a query with an ORDER BY clause using the code below.
我们的下一个例子,如图2所示,是一个含有ORDER BY子句的查询,它使用了下面的代码。
These operator choices provide further sorting control and accompany a given column in the ORDER BY clause.
这些操作符选择提供进一步的排序控制,伴随着ORDER BY子句中的给定列出现。
This happens if the cursor has an ORDER BY clause that USES an existing index (a work table is not created).
如果游标有使用现有索引的ORDER BY子句(不必创建工作表),会发生这种情况。
They can be simple, UNION, or joined sub-queries, including OUTER joins, and can include the ORDER BY clause.
它们可以是简单子查询、UNION或连接(包括OUTER 连接)子查询,并且可以包括ORDER BY 子句。
An OLAP function can be included in expressions in a select-list or the ORDER BY clause of a select-statement.
olap函数可以包括在一个select列表的表达式中或select语句的ORDER by子句中。
Like in a regular ORDER BY clause multiple columns can be specified in either ascending or descending sequence.
类似于在常规的ORDER by子句中,可以按升序或降序指定多个列。
To avoid unpredictable output in this situation, we would need to code the ORDER BY clause (even before DB2 9).
要避免在此情形下出现无法预期的输出,我们将需要编写ORDER BY子句(甚至在DB 2 9之前)。
The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
可在ORDER BY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。
When the framework appends the ORDER BY clause to the recordset's SQL query, the clause controls the selection's ordering.
框架向记录集的SQL查询追加ORDER BY子句后,该子句控制选定内容的排序。
You cannot use a column with RAND() values in an ORDER BY clause, because ORDER BY would evaluate the column multiple times.
查看官方手册,也说rand()放在ORDER BY 子句中会被执行多次,自然效率及很低。
The temporarily created field SORT is used within the ORDER BY clause, to get the result returned in the depth-first sequence.
临时创建的字段sort用于ORDER by子句内,以便按深度优先顺序获得返回的结果。
Next, ensure that the index has these columns in the proper sequence (according to the ORDER BY clause), so that a sort can be avoided.
接下来,确保索引中这些列有适当的顺序(按照ORDER by子句),这样可以避免排序。
Add ORDER by Clause dialog box enables you to further define a SELECT statement for a SQL data source by specifying how the results are sorted.
“添加order by子句”对话框可以通过指定结果的排序方式,进一步为SQL数据源定义SELECT语句。
The only differences might be in the order of rows in the table, although this will be consistent with any ordering specified by an order by clause.
唯一的区别可能是表中行的顺序不同,尽管结果表中行的顺序与ORDER BY子句所指定的任何排序顺序一致。
TOTAL_SORT_TIME: the total elapsed time (in milliseconds) for all sorts that have been executed by the statement (e.g. query statement using ORDER by clause).
TOTAL_SORT _ TIME:该语句已经执行的所有排序的总消耗时间(微秒级)(例如,使用ORDER BY子句的查询语句)。
The clauses of the query - such as its selection terms, the selection predicate in a WHERE clause, and ordering terms in an order BY clause - can all be mutated.
可以改变查询的子句,比如它的选择条件、WHERE子句中的选择谓词和ORDER BY子句中的排序条件。
If you add an order by clause, to order by the extracted city value, the result set still remains the same: Paris, Paris, and Paris are treated as the same value.
如果通过添加order BY子句按提取的city值排序,那么结果集仍然是相同的:paris、paris和paris被当作相同的值。
This control is provided in the form of the ORDER BY clause in conjunction with the order in which table qualified column names appear in the query elements table.
这种控制通过ORDER BY 子句以及表合格列名称在查询列表格中出现的顺序实现。
Note that an order by clause in the SELECT statement would not have any effect on the order of the array elements, as it would apply to the rows returned by the statement.
请注意,select语句中的ORDER BY子句不会对阵列元素的顺序产生任何影响,因为它将应用于该语句返回的行。
The row order in the query elements table in which columns are defined determines their left to right sequence within the order BY clause, which in turn determines their sorting priority.
定义了列的查询元素表中的行顺序决定了它们在ORDER BY子句中从左到右的顺序,这又确定了它们的排序优先级。
Adding an ORDER siblings BY clause which is only allowed in composition with the hierarchical query clause and will return the siblings in the predefined sequence.
添加一个ORDERSIBLINGSBY子句,该子句只能与分级查询子句组合使用,并且将按预先定义的顺序返回同级查询结果。
In the next example, the previous query is modified, by adding an ORDER by siblings clause to get the siblings in the result sorted by NAME.
在下一个示例中,会修改以前的查询,添加一个ORDER BYsiblings子句,从按照NAME排序的结果中获取同级查询结果。
The order by posted desc clause forces the query to return rows in descending order by the date in the posted column (which is the date that the article was posted on the Web site).
order byposteddesc子句强迫此查询按posted列中的日期(即文章发布到Web站点的日期)的降序返回行。
The criteria to sort an array of objects is usually formed by the name of the fields, and an indication of ascending or descending order (like an SQL "order by" clause).
排序一组对象的标准通常由域的名称形成,同时指出是升序还是降序。
The unfair judgement of overbearing clause can be carried on by way of economic analysis. And we analyse its reason in order to provide strategic basis for eradicating overbearing clause.
对霸王条款显失公平的判断可以通过经济分析的方法进行,分析其成因旨在为铲除霸王条款提供决策上的依据。
The second and the third parts of this thesis demonstrate that the SVCs are on a lower level in grammaticalization, which can be seen by the constraints of word order and clause integration.
第二、三两章分别从词序凝固化、小句整合两个方面,也就是从连动式的内部、外部证明连动式是句法化程度较低的句法结构。
应用推荐